Link to home
Start Free TrialLog in
Avatar of visualbasic
visualbasicFlag for Ireland

asked on

what does this error mean???????????????

Hello
I get the following error
-2147467259[Microsoft][ODBC dBase Driver]Selected collating sequence not supported by operating system
on this line of code
 pvStrRecordSource = "SELECT `INDEX`, NUMMER, HGRUPPE, KNAME, KNAME2, KNAME3, KNAME4, SPKARTE, SPKARTE2, SPKARTE3, SPKARTE4, PREIS, FOLGE, FESTPREIS, BONZIEL, NOTALON, NOGUTSCH, NORECH, DOOVERVIEW, RABATT, PROVISION, BEILZWANG, BEILGRP, BEILSEITE, AUSWERT1, AUSWERT2, AUSWERT3, AUSWERT4, AUSWERT5, REZEPTUR, EINSTPR, SCHANK, CHGPREIS, HANDY, MWSTIN, MWSTOUT, CHTIME FROM HISTSPEI ORDER BY `INDEX`"

 pvOptEnmCursorTypeEnum = 2
 '\\OPEN SOURCE RECORDSET
 '\\ERROR HAPPENS HERE
 prDB_ADORecordset_Srce.Open pvStrRecordSource, prDB_ADOConnection_Srce, pvOptEnmCursorTypeEnum, adLockPessimistic, adCmdText

what does that error mean?
Cheers T
Avatar of corvanderlinden
corvanderlinden
I suppose INDEX is a table column and not a literal. So do not use single qoutes because ORDER BY INDEX is not valid if INDEX is a litteral
Avatar of corvanderlinden
corvanderlinden
I suppose INDEX is a table column and not a literal. So do not use single qoutes because ORDER BY INDEX is not valid if INDEX is a litteral
ASKER CERTIFIED SOLUTION
Avatar of timytlee
timytlee
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial