creating 2 storedprocs

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

1 messages

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

1 total messages Started by Alex Liu Wed, 28 Dec 2005 02:06

#17

Author: Alex Liu
Date: Wed, 28 Dec 2005 02:06

28 lines
1662 bytes

Hi,

I want to create 2 store proc at run-time using TSQLStoredProc and found 
something "interesting":

[CASE 1]
TSQLStoredProc *sp_A, *sp_B;
sp_A = new TSQLStoredProc(App->mainform);
sp_A->SQLConnection = my_SQL_Conn;
sp_A->StoredProcName = "Proc_A";
sp_B = new TSQLStoredProc(App->mainform);
sp_B->SQLConnection = my_SQL_Conn;            <== EA occurs here
sp_B->StoredProcName = "Proc_B";

[CASE 2]
TSQLStoredProc *sp_A, *sp_B;
sp_A = new TSQLStoredProc(App->mainform);
sp_B = new TSQLStoredProc(App->mainform);
sp_A->SQLConnection = my_SQL_Conn;
sp_B->SQLConnection = my_SQL_Conn;
sp_A->StoredProcName = "Proc_A";
sp_B->StoredProcName = "Proc_B";
// OK no EA

I dont know why it is so... any idea please?
should i HAVE to use implementation of case 2?

Thanks in advance.

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