>>When i paste a SQL-statement generated by a view i get an 'unrecognized phrase/keyword in command' error.
>>Only when i reduce my SQL-statement in my SQLEXEC() to 255 characters or less it works.
>>
>>Why can't i use strings larger then 255 characters?
>>
>>Marco Beuk.

>A single line of code cannot be > 255 characters, however a single command can be up to 8192 characters long.

>You need to use the ; syntax to break up the command into a number of lines.
>Regards
>Mark

The SQL generator for the view does that for me, but still, it doesn't work.

The following command errors 'unrecognized phrase/keyword in command' because it contains more then 255 characters:

SQLEXEC(nHandle,"SELECT B_org.ORGID, M_internet.INTOMS AS email,;
M_adres.ADRSTRPB AS straat, M_adres.ADRHSPBNR AS huisnr,;
M_adres.ADRHSPBPC AS postcode, M_adres_a.ADRSTRPB AS postbus,;
M_adres_a.ADRHSPBNR AS postbusnr, M_adres_a.ADRHSPBPC AS postcode_pb,;
M_telefonie.TELOMS AS telefoon, M_internet_a.INTOMS AS site,;
M_internet_b.INTOMS AS ftp, M_telefonie_a.TELOMS AS telefax,;
B_org.ORGZOEKNM AS zoeknaam, B_org.ORGNAAM AS naam,;
B_org.ORGSBIHFDCD AS sbi_hoofd, B_org.ORGSBINEVCD AS sbi_neven,;
B_org.ORGMEMO AS memo, M_adres_a.ADRLANID AS lanid_pb,;
M_adres.ADRLANID AS lanid;
FROM dbo.B_ORG B_org, dbo.M_ADRES M_adres,;
dbo.M_TELEFONIE M_telefonie, dbo.M_INTERNET M_internet,;
dbo.M_INTERNET M_internet_a, dbo.M_INTERNET M_internet_b,;
dbo.M_ADRES M_adres_a, dbo.M_TELEFONIE M_telefonie_a,;
dbo.S_TAAL S_taal, dbo.M_ADRES M_adres_b, dbo.S_VORM S_vorm;
WHERE B_org.ORGADRIDB = M_adres.ADRID;
AND B_org.ORGTELIDT = M_telefonie.TELID;
AND B_org.ORGINTIDE = M_internet.INTID;
AND B_org.ORGINTIDU = M_internet_a.INTID;
AND B_org.ORGINTIDF = M_internet_b.INTID;
AND B_org.ORGADRIDP = M_adres_a.ADRID;
AND B_org.ORGTELIDF = M_telefonie_a.TELID;
AND B_org.ORGTALID = S_taal.TALID;
AND B_org.ORGADRIDF = M_adres_b.ADRID;
AND B_org.ORGVRMID = S_vorm.VRMID;
AND B_org.ORGID = ?ThisFormSet.OrgId", "crsOrg")