Subject | Delphi 5 + BDE |
---|---|
Author | Jukka Raisio |
Post date | 2004-03-18T16:21:38Z |
Seems to work, but TTable seems to be problem. It opens,
but short usage of it causes EAccessVialation in SQLINT32.DLL(interbase
library)
is there knowledge about update for this? How I should work with BDE,
Shortly other stuff about 1.5
BDE NATIVE Interbase VERSION 4.0 works with intensive TQuery usage
MSSQL --- Firebird datatypes
float (8bytes) = double precision
datetime (8bytes) = timestamp
int IDENTITY (1, 1)= ??? what is this in Firebird (automatic
identity for the record)
SQL functions is there equivalents to these MSSQL stuff
@@spid, -- Current process id ->
getdate(), -- Current time in the server ->
suser_name(), -- Current username ->
host_name(), -- Current hostname of the client ->
excample:
DELETE FROM APU WHERE TASK=@@spid ;
select @@spid,getdate(),suser_name(),host_name() from apu where a=1;
Any good FAQ document?
------------------------------------------------
MCSE = Minesweeper Consult, Solitare Expert.
------------------------------------------------
but short usage of it causes EAccessVialation in SQLINT32.DLL(interbase
library)
is there knowledge about update for this? How I should work with BDE,
Shortly other stuff about 1.5
BDE NATIVE Interbase VERSION 4.0 works with intensive TQuery usage
MSSQL --- Firebird datatypes
float (8bytes) = double precision
datetime (8bytes) = timestamp
int IDENTITY (1, 1)= ??? what is this in Firebird (automatic
identity for the record)
SQL functions is there equivalents to these MSSQL stuff
@@spid, -- Current process id ->
getdate(), -- Current time in the server ->
suser_name(), -- Current username ->
host_name(), -- Current hostname of the client ->
excample:
DELETE FROM APU WHERE TASK=@@spid ;
select @@spid,getdate(),suser_name(),host_name() from apu where a=1;
Any good FAQ document?
------------------------------------------------
MCSE = Minesweeper Consult, Solitare Expert.
------------------------------------------------