If you can't from the R> and you can from the designer, I think it is time for a bug report. I have on occasion found the designer would do things that were not technically allowed.
I do all changes on my live db in code. As you see, this methodology saves you from headaches later. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, July 14, 2010 4:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How to make this Delete command faster but, I made the Index on all 3 columns using the Design mode? Then Unloaded the structure, cut and pasted the Index code. So maybe you can't Index varchars form the R>? I think it is due to sun spots and solar activity! Marc -------------------------------------------------- From: "Albert Berry" <[email protected]> Sent: Wednesday, July 14, 2010 3:43 PM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Re: How to make this Delete command faster > That's entirely possible. I did not notice that the column was varchar. > Albert > > MDRD wrote: >> Albert >> >> CREATE INDEX SxTC ON `TravCard` ( `Subjx` ASC ) >> error >> this works >> CREATE INDEX SxTC ON `TravCard` ( `sympt1` ASC ) >> >> Subjx is a Varchar, Is Indexing Varchar is allowed?? >> This is my first Varchar column. >> Marc >> > >
