Can't insert into new table

Andy Hilton andyh at totallybrilliant.com
Sun Jan 3 22:55:20 UTC 2021


Is your primary key field set to auto increment ?

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com

> On Jan 3, 2021, at 5:44 PM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Hello All,
> 
> I have made a new schema and dragged it onto the SQLBrowser Tables option in the Browser.
> 
> I have made a Table Class for it and it has the schema name in the SQL class property.. it has tMaster as it’s superclass
> 
> The data is in the row I made for it as a task variable.. all just like my other schemas
> 
> Everything seems to be ready.. I have relaunched my app
> 
> The database table exists.. but it won’t save data
> 
> I am using everything that way I do with all my other schemas.. should work..
> 
> When I use the $insert command it goes into my SQL error trap but all of the available things that show error text normally are saying Empty or Null, so there’s no reporting back to me on what the error is.. the flag is true for the insert command but it goes into my error trap with no reporting back on what it is.
> 
> Since everything is as it should be.. I can’t figure out where the problem is
> 
> Is there something I’m forgetting that one has to do to create a new schema, it’s database table, and insert data?
> 
> Thanks
> 
> Das Goravani
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list