uniqueidentifer in SQL Server 2005

Thread View: borland.public.cppbuilder.database.dbexpress

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Remy Lebeau (TeamB) Wed, 16 Jul 2008 21:55

#196

Author: Remy Lebeau (TeamB)
Date: Wed, 16 Jul 2008 21:55

13 lines
1696 bytes

I am using dbExpress (not sure the version) with BCB 6.  It does not appear 
to support "uniqueidentifer" types in TParams.  I keep getting errors 
whenever I try to use ftGuid or ftString.  I need to run SQL Server 2005 
stored procedures that have "uniqueidentifier" parameters, both INPUT and 
INPUT/OUTPUT parameters.  For now, I'm having to manually run "EXECUTE" 
statements using TSQLDataSet, which at least works for input, but I can't 
get OUTPUT values from it (or is there a way to do it?).

Does the latest dbExpress (is it available for BCB 6?) support 
"uniqueidentifier" yet?


Gambit

Re: uniqueidentifer in SQL Server 2005

#197

Author: Remy Lebeau (TeamB)
Date: Thu, 17 Jul 2008 17:01

13 lines
1366 bytes

"Remy Lebeau (TeamB)" <no.spam@no.spam.com> wrote in message 
news:487e6e8f$1@newsgroups.borland.com...

> For now, I'm having to manually run "EXECUTE" statements using
> TSQLDataSet, which at least works for input, but I can't get OUTPUT
> values from it (or is there a way to do it?).

I figured out a way to do it, by adding DECLARE and SELECT statements to the 
SQL query.


Gambit

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads