I had a requrest to allow the user to change order on a maintnence form.
The original form only had one option for search. My session is based on timrp943 table. When I added the option on the form to change the search order,and i scroll to the next record, I am getting the following errors:
host variable expected after ':'
Syntax error: '.' not expected
Found 2 errors durig scanning/parsing
Error 302 (SQL Syntax not correct) on select
How can I get this to work?

Hi

What kind of form is this 1, 2 or 3 also it would help if you can send screen dump. And how many indexes does this table have.

I noticed that the table shows only one index, but in GTM i can see 2 indexes.
Is this hte issue??
It is a type 3 form.

Hi

When you say table shows only one index, do you mean its in table definition session in tools ?

And how GTM is showing 2 indexes if its only one table definition, is it the right company you are looking into ?, Also can you check is this table is the main table for the session.

Follow the steps once you are through with above

Actually the table definition and GTM should be in sync:

Step 1: Do a convert to run time for the table definition and run a reconfig also for same int he respective company

Step 2: If even then the problem exist, do a convert run time for the session also.

The table with 2 indexes was in a different VRC. I copied this to the proper VRC, but still having the same errors.
Is is in the program script??

Hi

After copying it to proper VRC did you followed the 2 steps that i have mentioned in my previous reply. Try doing it, i think the problem should get resolve. Because Change order is Baan Standard and i don't think any thing in script should effect that.
And did you check that the table you are mentioning is Main table for that session, then only its going to work otherwise not.

Hi,

You can also check with change key option in maintain session. There might be select only one index.

Sanjay

Hi,

You can also check with change key option in maintain session. There might be select only one index.

Sanjay
Where is this change key option

Hi

If you are using BAAN IV it is on ttadv2100m000 Maintain Session, i think its Ctrl F4 just check it on this session. In that it has got how many index are currently applied to session .

I have updated the indexes in the session, create runtime, but still the same errors as mentioned in the first posting. Would this have anything to do with the program script?