[Solved] SQL/Macro Problem

gkick · Post by **gkick** » Mon Aug 17, 2020 3:50 pm

Hi,

Win10 LO6.4.6 HSQL2.51

getting some error message on an ALTER statement, can not find the table, but the table is there and causes no problems in a couple of forms. Tried to prefix the tablename with PUBLIC, but then it can not find PUBLICPUBLIC.
Any idea whats wrong ? Although not macro related in this db I also have a redundant form which refuses to be deleted and can not be opened.

Thanks for your thoughts

Post by **RoryOF** » Mon Aug 17, 2020 4:00 pm

You may have overlooked the "user privileges" part of the message.

edit this topic's initial post · Post by **Villeroy** » Mon Aug 17, 2020 4:06 pm

The name ""tblTaxRates "" has a trailing space

gkick · Post by **gkick** » Mon Aug 17, 2020 8:01 pm

@Villeroy

Wow, thanks !!!

gkick · Post by **gkick** » Mon Aug 17, 2020 8:05 pm

@RoryOF

Thanks, no prob with privilege as logged in as SA

[Solved] SQL/Macro Problem

[Solved] SQL/Macro Problem

Re: SQL/Macro Problem

Re: SQL/Macro Problem

Re: SQL/Macro Problem

Re: [Solved]SQL/Macro Problem