what is wrong with this string??

[inteleserve]

The string below works in foxpro8 but I need to get this to work in 2.6 for unix. Obviously my directories are different from going from NT to unix, but that shouldn't matter. I am thinking that 2.6 just needs this string entered in differently...

PLEASE HELP ME FOR THE LOVE OF GOD!!!


Erin Goodrich


insert into /u/server/data/temp.dbf (fullname) select (fullname) from /u/server/data/alliedma.dbf where phone!="

 

[DSummZZZ]

What problem are you having?
Do you have EXACT set on or off?
Are you getting an error?
Too many records?
Not enough records?
.
.
.

Elaborate a little please.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[inteleserve]

I got a syntax error when I tried this on foxpro 2.6 on unix

INSERT INTO /data/tmp.dbf (fullname) SELECT (fullname) FROM /data/DATAFILE.dbf where phone!=" "

 

[rgbean]

Erin,
I'm afraid it's more than a simple syntax problem. The SQL INSERT syntax with a SELECT wasn't introduced until VFP 8.0. There isn't anything like it even in VFP 7.0, much less FPU.
About the best you can do is:

SELECT (fullname) FROM /data/DATAFILE.dbf ;
 where !EMPTY(phone);
 INTO Cursor curTemp
SELECT curTemp && probably not needed
SCAN
 INSERT INTO /data/tmp.dbf (fullname) ;
   VALUES (curTemp.fullname)
ENDSCAN
USE && kill the cursor

Rick

 

[TheRambler]

Hi,

The correct syntax is:

INSERT INTO <dbf name>
[(<field name1>
[, <field name2> [, ...]])]
VALUES (<expr1>
[, <expr2> [, ...]])