Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem updating tables from Stored Procedure
Message
From
27/06/2006 12:54:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01132012
Message ID:
01132091
Views:
22
>>Oh wait a min it's a free table. Then Datafolder is higher suspect:) Is it a fullpath or relative? For a free table you can connect to folder. ie:
>>string strConn = "Provider=VFPOLEDB.1;Data source=d:\\temp;"
>>
>>In your stored procedure add code to check where it's really adding. ie: After use line:
>>
>>StrToFile(dbf(),'c:\Info.txt')
>>
>
>I don't think you can use StrToFile() in Stored procedure called via Ole DB. I usually create a dummy .dbf for that purpose.

Dmitry,
Sorry you're of course right:) However still I think you can return info just to the caller with slight modification:
*After use
lcDBF = Dbf('aliashere')
...
return m.lcDBF
ASP.net add say a label named lblInfo.
  OleDbCommand cmd = cn.CreateCommand();
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = "StoredProcName";
  lblInfo.Text = (string)cmd.ExecuteScalar();
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform