Search results for query: *

Hi all, i have a time_interval on my datawindow for automatic refresh and it works very fine. is it possible to stop the timer_interval event in case i dont need it ? i tryed 2 methodes but it did not work : 1 ) dw_deliverables.Modify("DataWindow.Timer_Interval=0") the interval is set to 1...

yes i think a permission problem , i m not the admin for this DB i moved to ODBC drive thanks

i think PB8 is not good for OLEDBSAL connection, so i moved to using ODBC and all works fine maybe in PB 9 they enhance somthing , i dont know .. thanks Mounir

RDBMS: Sql server 2000 (ODBC drive) PB 8.0.3 i try to run an stored proc that have 2 arguments : string ls_user, ls_approval ls_approval = Fill(" ", 1) SQLCA.sp_acq_ca_aprroval(ls_user,ref ls_approval ) under MSS sql server driver (6.5) i get the ls_approval value but using ODBC driver i get...

trying to connect via OLE driver but i go this message : Ctalog Tables could not be created or not available.. any idea

for more infos i found that : In MSS, you can specify that the DB truncate trailing spaces. See ANSI_PADDING. This really becomes a nuisance when either performing string comparisons (pre-MSS 2000) or concatenating strings (e.g. "Dale " + "Fox " becomes "Dale Fox " instead of "Dale...

i m moving from MSS driver to ODBC driver and I m noticing that when I select a text field it gives me spaces after the text any idea ? thanks a lot Mounir

are you sur ? someone asked me this question in an interview..@#$%^&* ;) thanks a lot

in fact , my query worked very well using the old driver of Mss sql server 6.5. Now i m trying to using the ODBC driver. the same query give me this error select * from mytable; thnks a lot

how can i update two tables in one statement update ? thanks

hi, using sql server 2000 sp3a using ODBC for sql server driver , when i m trying to execute a stored proc , got this message : [Microsoft][ODBC Sql server Driver] Invalid character value for cast specification thanks for your help Mounir Youssef

hi all, i found that they are using the MSS sql sever 6.5 driver to connect to the database. that cannot support data bigger than 255 characters. i tried ODBC or OLE DB and it works. another probleme appers that via oDBC drivers cannot see the stored procedures (spo.mystoredprocedure)...

thanks for your fast replies, OKi , in my SQl query analyser i can see that there is more that 255 characters thanks. in my front-end application; i m using the standard update statement to update the decription filed and the update is succeful. but i try to select this field it s always...

Hi all, using sql server 2000 sp3 i have filed (description varchar(370)), i can update this field (with 370 characters ) but when i select it i get always 255 characters it means the data is truncated up to 255 chars. do you have any idea about that or some work arround. ? thanks a lot...