message box in VISUAL FOXPRO

[Guest_imported]

hi guys

i am using sqlconnect,sqlexec functions in visual foxpro . i created one procedure in sql server . i called that procedure in visual foxpro . "but raiseerror message does not display in visual foxpro" i dont know why ?
if somebody know please let me know

thanks & regards
m.a.khaleel

 

[TomasDill]

Hi!

SQLEXEC do nto cause error firing when error happened on the SQL Server. SQLEXEC() just return -1 if errors happened. In your program check if SQLEXEC() was successful. If not, you can get ALL error and warnign messages from server using AERROR() function.

HTH.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[foxdev]

Immediately after the SQLEXEC() statement, store and view the results from MESSAGE().

Also, this would have been better in the VFP forum. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com