Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can i use locate in procedure

Status
Not open for further replies.

ssparvathaneni

IS-IT--Management
Jun 3, 2003
1
MY
i try to write a stored procedure to update a table having
text field as shown billow

create procedure tdup()
define vfile BYTE;
locate vfile in file "testlo"
update ss set ss2 = vfile where ss1 = 9
end procedure;

ss is my table and ss2 is text data type field and ss1 is numaric.

and i don't have the CSDK so i can use only dbaccess,thats the reasion i writen this procedure.
thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top