Confused

  • Thread starter Thread starter Ranmara
  • Start date Start date
R

Ranmara

I am trying to insert a VFP table with an ADO Connection utilizing the
VFPOLEDB.1 driver.

My SQL (being generated in excel/vba) is (excluding the semi-colons - there
for Fox Pro Command window)

INSERT INTO SY(;
adp, aicalctype, aidaybasis, aidaycount, amortmeth, best, bloomberg,
bridge, [carry], cbsycode, ;
clcode, cnvcur, cnvinto, cocode, commrate, cpncur, cpnformula, cpnfreq,
cpntype, cucode, ;
cusip, derivative, euroclear, excode, excucode, feedquery, gensy2desc,
gensycode, gensydesc, gensymbol2, ;
gensymbol3, gsco, gscoprime, gsstcode, gssycode, idc, ilx, indgr, isin,
isvarrate, ;
lehm, login, merrin, moody, motc, msco, oldsycode, pikformula, preffeed,
procucode, ;
pscucode, quik, refundtype, remarks, reuters, rlbrcode, rlsycode, sacode,
salesman, sedol, ;
series, sgcode, shark, smcode, sncode, sp, [status], stcode, sycode,
sydesc, ;
[time], aifirstdt, aifirstset, announcedt, cnvfirstdt,
cnvlastdt, cpnchgdt, cpnfirstdt, [date], expiredt, ;
filedate, maturity, nextcalldt, nextputdt, syid, accreted,
accretion, amortflag, contract, [convert], ;
cxflag, dbtdefault, evwarning, ismethod, multchg, preferred, pricemult,
reportchg, secfee, ;
sygen, ;
sygen2, uniqueid, accrerate, accrrate, amortfact,
callprice, cnvprice, cnvratio, cpnchgrate, cpnrate, ;
facevalue, fxrate, initprice, initsize, isfixrate, [margin], marketable,
[mult], nfafee, notional, ;
oshares, outshares, outstand, putprice, roundlot, strike) VALUES(;
'65654', '', '360', '30', '', '', '61745P817', '', '', '', ;
'', '', '', '', '', '', '', '', '', 'USD', ;
'61745P817', '', '', 'NYSE', 'USD', '', '', '', 'IMB2', '', ;
'', '', '', '', '', '', '', '', 'US61745P8178', 'N', ;
'', 'SYMAN', '', '', '', '', '', '', '', 'USD', ;
'USD', '', '', '', '', '', '', '', '', '2459923', ;
'', 'ZERO', '', 'CSH', '0001', '', 'A', 'STO', 'IMB2', 'MORGAN STANLEY INSD
MUNI BD', ;
'10:29', {}, {}, {}, {}, {}, {}, {}, {^2003-09-16}, {}, ;
{}, {}, {}, {}, 0, .T., .T., .T., .T., .F., ;
..T., .T., .T., .T., .T., .F., 0, .T., .T., .F., ;
..T., .T.,0, .0000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ;
0.0, 0.0, 0.0, 0.0, 1.0, 1.0, 3, 1.0, 0.0, 0, ;
0, 0, 0.0, 0.0, 0, ;
0.0)

And works fine in the Command Window.
However it generates the old "Syntax Error" when
running the VBA and executing.

Any ideas would be appreciated as I have run into a gauntlet I belive.

My Connex string is as follows: "Provider=VFPOLEDB.1;Data
Source=\\<MACHINE_IP>\PATH\DB.DBC;Mode=ReadWrite;Extended Properties="";User
ID=SYMAN;Password=SYMAN;Mask Password=False;Cache
Authentication=False;Encrypt Password=False;Collating Sequence=GENERAL

All the datatypes work thus I am able to do the insert from the command win.


?????

Perplexed
 
NM
I got it myself. It wanted a full path to the dbf so instead of
INSERT INTO SY
use
INSERT INTO \\machine\path\SY.dbf
BTW yer all newbs

LOL
j/k


Ranmara said:
I am trying to insert a VFP table with an ADO Connection utilizing the
VFPOLEDB.1 driver.

My SQL (being generated in excel/vba) is (excluding the semi-colons - there
for Fox Pro Command window)

INSERT INTO SY(;
adp, aicalctype, aidaybasis, aidaycount, amortmeth, best, bloomberg,
bridge, [carry], cbsycode, ;
clcode, cnvcur, cnvinto, cocode, commrate, cpncur, cpnformula, cpnfreq,
cpntype, cucode, ;
cusip, derivative, euroclear, excode, excucode, feedquery, gensy2desc,
gensycode, gensydesc, gensymbol2, ;
gensymbol3, gsco, gscoprime, gsstcode, gssycode, idc, ilx, indgr, isin,
isvarrate, ;
lehm, login, merrin, moody, motc, msco, oldsycode, pikformula, preffeed,
procucode, ;
pscucode, quik, refundtype, remarks, reuters, rlbrcode, rlsycode, sacode,
salesman, sedol, ;
series, sgcode, shark, smcode, sncode, sp, [status], stcode, sycode,
sydesc, ;
[time], aifirstdt, aifirstset, announcedt, cnvfirstdt,
cnvlastdt, cpnchgdt, cpnfirstdt, [date], expiredt, ;
filedate, maturity, nextcalldt, nextputdt, syid, accreted,
accretion, amortflag, contract, [convert], ;
cxflag, dbtdefault, evwarning, ismethod, multchg, preferred, pricemult,
reportchg, secfee, ;
sygen, ;
sygen2, uniqueid, accrerate, accrrate, amortfact,
callprice, cnvprice, cnvratio, cpnchgrate, cpnrate, ;
facevalue, fxrate, initprice, initsize, isfixrate, [margin], marketable,
[mult], nfafee, notional, ;
oshares, outshares, outstand, putprice, roundlot, strike) VALUES(;
'65654', '', '360', '30', '', '', '61745P817', '', '', '', ;
'', '', '', '', '', '', '', '', '', 'USD', ;
'61745P817', '', '', 'NYSE', 'USD', '', '', '', 'IMB2', '', ;
'', '', '', '', '', '', '', '', 'US61745P8178', 'N', ;
'', 'SYMAN', '', '', '', '', '', '', '', 'USD', ;
'USD', '', '', '', '', '', '', '', '', '2459923', ;
'', 'ZERO', '', 'CSH', '0001', '', 'A', 'STO', 'IMB2', 'MORGAN STANLEY INSD
MUNI BD', ;
'10:29', {}, {}, {}, {}, {}, {}, {}, {^2003-09-16}, {}, ;
{}, {}, {}, {}, 0, .T., .T., .T., .T., .F., ;
.T., .T., .T., .T., .T., .F., 0, .T., .T., .F., ;
.T., .T.,0, .0000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ;
0.0, 0.0, 0.0, 0.0, 1.0, 1.0, 3, 1.0, 0.0, 0, ;
0, 0, 0.0, 0.0, 0, ;
0.0)

And works fine in the Command Window.
However it generates the old "Syntax Error" when
running the VBA and executing.

Any ideas would be appreciated as I have run into a gauntlet I belive.

My Connex string is as follows: "Provider=VFPOLEDB.1;Data
Source=\\<MACHINE_IP>\PATH\DB.DBC;Mode=ReadWrite;Extended Properties="";User
ID=SYMAN;Password=SYMAN;Mask Password=False;Cache
Authentication=False;Encrypt Password=False;Collating Sequence=GENERAL

All the datatypes work thus I am able to do the insert from the command win.


?????

Perplexed
Click to expand...
 
Back
Top