on 12-20-2013 3:25 PM
Hi
I'm Creating one # table(#temp) through source code, then insert some values into the #table and later i'm using the same # table in a procedure to retrieve the values and then drop the same #table in procedure .
But i'm not able to retrieve the values from #table in procedure. and it is retireving an error sometimes or empty values
From my observation, Since the #table is creating through powerbuilder source code using SQLCA, it is not synchronizing the with the same #table used in procedure and moreover my appliation is user by multiple users so in multiple sessions the same #table may not sync with the table used in procedure.
Please look over it and let me know your suggestions.
You might want to post this over in the PowerBuilder Developer Center.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi, you create global temp table (##temp) or create a permanent table and delete/insert data as per your requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vikrant,
Thanks for responding...
My requirement is clearly to use # table only...
So if there is any way to use the same # table in source code and in the procedure ... Needs to work in multiple sessions... i.e. for one session, the # table is deciated to the corresponding user who is using the # table from source code to procedure...
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.