cancel
Showing results for 
Search instead for 
Did you mean: 

Using question marks ? in Mobilink scripts

Baron
Participant
0 Kudos
925

Is it not anymore supported in SQL Anywhere 17 replacing the column names in mobilink scripts with questions marks?

In some upload_insert script we call another procedure like: call mobilink_uplad(?, ?, ?), then the procedure gets the correct values but in incorrect order.

Is this already a known problem?

Accepted Solutions (0)

Answers (1)

Answers (1)

regdomaratzki
Product and Topic Expert
Product and Topic Expert

You can still use question marks in scripts instead of named parameters.

The order of values used is based on the order of the columns at the REMOTE database. Is it possible that the column order for a given table is not the same at the remote and consolidated database?

Reg

Baron
Participant
0 Kudos

both databases Remote and Cons. have the same structure.

In the logfile of DBMLSYNC I see also that row values are listed in the correct order, but at the end they are passed in a false order to the procedure.

Baron
Participant
0 Kudos

Moreover, the procedure being called from upload_insert script is also correct no doubt, because I only replaced the question marks with the column names and then it startet working!!!!

Could the delimiter (Default field separator) be a problem? I mean if the remote is using ',' as delimiter and the cons. uses ';'

regdomaratzki
Product and Topic Expert
Product and Topic Expert
0 Kudos

Please see the comments that Breck and I have made on your initial question.