error parsing query in pocket pc application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I'm implementing merge replication between a SQLCE 2.0 database on a
PocketPC device (PPC) and a SQL 2K database on a desktop (WinXP Pro). I'm a
ble to get synchronize and
run. but i am getting problem when i use two tables using inner join as show
n below


sql = "SELECT menu.menu_image, menu.menu_image" & _
"FROM menu " & _
"INNER JOIN mprg " & _
"ON menu.menu_id = mprg.menu_id "

drOrders = cmdOrders.ExecuteReader()
While drOrders.Read() ..

It is giving this error all the time i solved from microsoft kb for this pro
blem but giving same error.

Error Code: 80040E14
Message : There was an error parsing the query. [Token line number, Token
line offset,,Token in error,,]
Minor Err.: 25501
Source : Microsoft SQL Server 2000 Windows CE Edition
Num. Par. : 1
Num. Par. : 51
Err. Par. : INNER

How can I fix this problem? iam using sqlcesp3 and windows ce 2.0 . I did
merge replication in sql server . i also deleted the data from tables.
i used this option from microsoft : Select the Enforce relationship for rep
lication check box that is located under the Relationships tab of the Table
Design properties page (for each constraint) in the SQL Server Enterprise Ma
nager, and then re-run the Snapshot Agent.
But i am getting same error.
Looking forward for kind reply,
Pramod Renikindi
australia
 
Try this instead:

sql = "SELECT menu.menu_image, menu.menu_image " & _

(space was missing after '.menu_image')
 
Dear Sergey,
You are great my friend . Thanks for your help . Thanks a lot .
--
yours truly,
Pramod Renikindi,
email : (e-mail address removed)
(e-mail address removed)
creativesoft,
australia


Sergey Bogdanov said:
Try this instead:

sql = "SELECT menu.menu_image, menu.menu_image " & _

(space was missing after '.menu_image')



--
Sergey Bogdanov [.NET CF MVP, MCSD]
http://www.sergeybogdanov.com


Pramod said:
Hi All,

I'm implementing merge replication between a SQLCE 2.0 database on a
PocketPC device (PPC) and a SQL 2K database on a desktop (WinXP Pro). I'm a
ble to get synchronize and
run. but i am getting problem when i use two tables using inner join as show
n below


sql = "SELECT menu.menu_image, menu.menu_image" & _
"FROM menu " & _
"INNER JOIN mprg " & _
"ON menu.menu_id = mprg.menu_id "

drOrders = cmdOrders.ExecuteReader()
While drOrders.Read() ..

It is giving this error all the time i solved from microsoft kb for this pro
blem but giving same error.

Error Code: 80040E14
Message : There was an error parsing the query. [Token line number, Token
line offset,,Token in error,,]
Minor Err.: 25501
Source : Microsoft SQL Server 2000 Windows CE Edition
Num. Par. : 1
Num. Par. : 51
Err. Par. : INNER

How can I fix this problem? iam using sqlcesp3 and windows ce 2.0 . I did
merge replication in sql server . i also deleted the data from tables.
i used this option from microsoft : Select the Enforce relationship for rep
lication check box that is located under the Relationships tab of the Table
Design properties page (for each constraint) in the SQL Server Enterprise Ma
nager, and then re-run the Snapshot Agent.
But i am getting same error.
Looking forward for kind reply,
Pramod Renikindi
australia
Click to expand...
Click to expand...
 
Back
Top