Recent content by toutski

I am trying to edit the format of a bit field using a query. In design view, the format I want for the field is ";\1;0". When I write a query ALTER TABLE MASTPLU ADD ALLOWFLAG BIT FORMAT ;\1;0 I get a syntax error in alter table statement. Can this be done using a query??? Thanks.

The error is: Syntax error (missing operator) in query expression 'USERCARD.SERIALNO = CHIPTRAN.SERIALNO inner join MASTPLU on CHIPTRAN.MASTLINE = MASTPLU.MASTLINE inner join MAC on MAC.MACID = CHIPTRAN.MACID where...'

Hi, I was wondering if it is possible to join more than two tables inside a query. Im getting an error and I assume it is becaue im trying to join multiple tables. It works in SQL using: 'Select USERCARD.HOLDID, MASTPLU.LOYALTY_POINTS, CHIPTRAN.PLQTY from CHIPTRAN inner join USERCARD on...

I had a feeling you were going to say that! Many thanks.

I am updating a set of tables and am making a few changes. I can do all the changes I need to using single queies. Is it possible to combine all the queries into one window? I am trying to mirror a script written for some SQL server tables.