Re: Load Table in ESQL/C

In <C5uC78.Ar3@rnihd.rni.sub.org> klaus@rnihd.rni.sub.org (Klaus Brand) writes: >Hi Netlanders, >I've got following problem: >With ISQL I can easily load a table with >LOAD FROM "file_name" INSERT INTO table_name >Now I want ESQL/C to do the same job and here is the problem. >If I prepare a cursor with the line above I got a syntax error. >I think the problem are the quotation marks. I have tried null, one, two and >three quotations marks , but nothing worked. >So, is there a way to run this thing in ESQL/C ????? According to my manual "You cannot use the PREPARE statement to preprocess a LOAD statement" in I4GL. It also states that LOAD is only valid for I4GL, DB-Access and ISQL, not ESQL. I think they expect a 'C' programmer to want to read the file himself and stuff it into an insert cursor. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.