Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

You are correct that split DB's cannot edit table structure in the IDE. You can edit using an ALTER statement if needed but for what you are asking this does not apply. What you want is a change in the display format. This is done in various ways. For example, double click on the table to display the data. Next, right click the column heading and choose Column Format. Then choose the formatting you want. Form controls have their own properties for display.

Your statement about using RIGHT is incorrect. This works without problem in v2.4 as I have just re-tested it. The error is something else in the statement.

You can get the v2.4 pdf document here.

Hello,

You are correct that split DB's cannot edit table structure in the IDE. You can edit using an ALTER statement if needed but for what you are asking this does not apply. What you want is a change in the display format. This is done in various ways. For example, double click on the table to display the data. Next, right click the column heading and choose Column Format. Then choose the formatting you want. Form controls have their own properties for display.

Your statement about using RIGHT is incorrect. This works without problem in v2.4 as I have just re-tested it. The error is something else in the statement.

You can get the v2.4 pdf document here.

EDIT:

In your SQL, you may need to CAST a field or two to another type in order for it to work.