error parsing query in pocket pc application

[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

 

[Sergey Bogdanov]

Try this instead:

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

(space was missing after '.menu_image')

 

[Guest]

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

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

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