Browseing Records Error

Classic Servoy
1

I get this error every so often when browsing records on a form. I will be moving from record to record on one form one table and suddenly this error pops up on a particular record.

java.sql.SQLException: SQL ERROR - [position 266, near 'SoundsLike' in '6,157,158)? TAIL 21 TAIL '] (0)  and expected but not found at position 81.

SQL: select zip_codes._rowid, zip_codes.city, zip_codes.zip, zip_codes.st, zip_codes.state, zip_codes.county, zip_codes.area_code, zip_codes.country from zip_codes where zip_codes._rowid in (139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158)null TAIL 21 TAIL 21 SQL ERROR - [position 266, near 'SoundsLike' in '6,157,158)? TAIL 21 TAIL '] (0)  and expected but not found at position 81.

SQL: select zip_codes._rowid, zip_codes.city, zip_codes.zip, zip_codes.st, zip_codes.state, zip_codes.county, zip_codes.area_code, zip_codes.country from zip_codes where zip_codes._rowid in (139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158)null TAIL 21 TAIL 21

What does this mean?

I am using an OpenBase (8.0.4) backend for this form.

Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)

I have browsed the data with Aqua Data Studio and no errors popup on it.

2

aren’t you using youre own queries somehow?
Because the part “? TAIL 21 TAIL” is not generated by us.
And what is that ‘SoundsLike’ I don’t see that word anywhere in you sql.

3

I am completely new to Servoy and SQL. I come from a Filemaker background and that is only three years. I’m still going through the testing phase of Servoy to see what I can do and how easy.

jcompagner:
aren’t you using youre own queries somehow?.

I would not even know how to do my own queries. All I did was create a form link to this database’s table. Added the fields in the table to the form and started to browse the records. I would press ALT down arrow to move from record to record. Suddenly this error would popup.

jcompagner:
Because the part “? TAIL 21 TAIL” is not generated by us.
And what is that ‘SoundsLike’ I don’t see that word anywhere in you sql.

I do not know. All this stuff means gibberish to me.

4

then it really looks like an openbase error to me.

Can you export youre solution with sample data and then import it again using sybase (ships with servoy) or mysql/postgresql?

Then we can look if it is openbase or not.

5

jcompagner:
then it really looks like an openbase error to me.

Can you export youre solution with sample data and then import it again using sybase (ships with servoy) or mysql/postgresql?

Then we can look if it is openbase or not.

I imported the data into Sybase and began to browse the records. No errors occured. So this must be some type of OpenBase problem.

I am not sure why this happens because I have browsed the data from two other sql viewer softwares (Aqua Data Studio and SQL4X Manager) and they don’t give any errors.

I guess I will have to stick with Sybase, as it produces the least amount of errors with Servoy.