ssparvathaneni
IS-IT--Management
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
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