 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Dmitry Arefiev [gs-soft.r
Guest
|
 Posted: Mon Jan 19, 2004 9:26 pm Post subject: MSSQL and batch command (Ramesh ?) |
 |
|
Hello All !
I am executing following batch command:
INSERT INTO [master_autoinc] (NAME1) VALUES (?);
SELECT @@IDENTITY AS ID1
There [master_autoinc] table has 2 fields:
ID1 INT IDENTITY(1,1)
NAME1 VARCHAR(10)
Using dbExpress API i am performing steps:
- FCommandIntf.execute(FCursorIntf), FCursorIntf -> NIL
- FCommandIntf.getNextCursor(FCursorIntf), FCursorIntf -> cursor
returning result set of "SELECT @@IDENTITY AS ID1".
But in second step i am getting NIL as FCursorIntf. Is
that limitation, bug or what other ?
PS: Latest MSSQL dbExpress driver version.
Regards,
Dmitry
--
Dmitry Arefiev, gs-soft Company, community.gs-soft.com
Personal - www.da-soft.com
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access
|
|
| Back to top |
|
 |
Ramesh Theivendran
Guest
|
| Posted: Wed Jan 21, 2004 12:45 am Post subject: Re: MSSQL and batch command (Ramesh ?) |
|
|
getNextCursor() is mainly for SP returning multiple cursors. If the SQLOLEDB
ICommandText->Execute() supports returning a RowSet for batch command then i
would say its probably a feature not yet surfaced. Please log a case in QC
and i'll take a look.
T.Ramesh.
"Dmitry Arefiev [gs-soft.ru]" <darefiev (AT) gs-soft (DOT) ru> wrote
| Quote: | Hello All !
I am executing following batch command:
INSERT INTO [master_autoinc] (NAME1) VALUES (?);
SELECT @@IDENTITY AS ID1
There [master_autoinc] table has 2 fields:
ID1 INT IDENTITY(1,1)
NAME1 VARCHAR(10)
Using dbExpress API i am performing steps:
- FCommandIntf.execute(FCursorIntf), FCursorIntf -> NIL
- FCommandIntf.getNextCursor(FCursorIntf), FCursorIntf -> cursor
returning result set of "SELECT @@IDENTITY AS ID1".
But in second step i am getting NIL as FCursorIntf. Is
that limitation, bug or what other ?
PS: Latest MSSQL dbExpress driver version.
Regards,
Dmitry
--
Dmitry Arefiev, gs-soft Company, community.gs-soft.com
Personal - www.da-soft.com
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
