Ok, try this instead of create a temp table, create a table with the same structure in the database then modify the store procedure to fill this table and run it from query analizer.
Then create another table modify the store procedure to fill this second table using the datawindows.
Now you...
Run PROFILER from sql server and then do a retrieve of the datawindows.
In the profiler you will see how powerbuilder call the store procedure.
You can copy the exec statement and put it in the query analizer.
Hi
add 730 days, then calcuate
if this month is 1 or 2(i think you have to exclude 29 of february) then you must see if the year is leap or the next year is leap, if one of the two are lead add 1 more day.
if this month is greater than 28 of february then you must see the next 2 year to see if...
I use this in the .ini file
Vendors=MICOSOFT
DBMS=MSS Microsoft SQL Server 6.x
ServerName='servername'
Database='dbname'
DBParm=AppName='',Log = 0, host='computername',DBTextLimit='32000'
If you need help my mail is pcucho@yahoo.com
f i do this i get
long __declspec(dllexport) __stdcall cfinterfase(CString h)
{
CString d = "HELLO: ";
AfxMessageBox(d);
AfxMessageBox(h);
return 10;
}
Its display 2 message box 1 with HELLO and the other with the value of h
but if i change the last afxmessagebox with...
Hi,
i'm building a dll (with MFC) wich i need to call it from another language.
I declare it in this way
long __declspec(dllexport) __stdcall cfinterfase(CString h);
in the body of the function i need to concatenate 2 string 1 is the argument.
so i do this
long __declspec(dllexport)...
I have a problem when i want to use nested cursor and i found this.
declare the first cursor, then declare the second and when you close the second cursor deallocate it
ex
declare first_cursor cursor for
select * from ff
open first_cursor
fetch first_cursor into @gg
while (@@sqlcode=0)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.