JDBC using REFERENCES

2024-11-24 Thread Arbol One
In an application that uses JDBC I am trying to use the following statement *   // Table parameters     var sql = new MyString();     sql.setData("CREATE TABLE IF NOT EXISTS ");     sql.append(this.tableName);     sql.append(" (");  

Re: JDBC using REFERENCES

2024-11-24 Thread David G. Johnston
On Sunday, November 24, 2024, Arbol One wrote: > > > > > * sql.append("index SERIAL NOT NULL, "); > sql.append("id TEXT PRIMARY KEY, "); sql.append("CONSTRAIN > id PRIMARY KEY (id)"); **<== Error* > > > This is quite confusing, having the index column be serial but

Re: JDBC using REFERENCES

2024-11-24 Thread Rob Sargent
> On Nov 24, 2024, at 7:15 PM, Arbol One wrote: > >  > In an application that uses JDBC I am trying to use the following statement > >// Table parameters > var sql = new MyString(); > sql.setData("CREATE TABLE IF NOT EXISTS "); >

Re: JDBC using REFERENCES

2024-11-24 Thread David G. Johnston
On Sunday, November 24, 2024, Arbol One wrote: > > * sql.append("CONSTRAIN id PRIMARY KEY (id)"); **<== > Error* > > > The word constraint ends with a “T” David J.

JDBC using REFERENCES

2024-11-24 Thread Arbol One
In an application that uses JDBC I am trying to use the following statement *   // Table parameters     var sql = new MyString();     sql.setData("CREATE TABLE IF NOT EXISTS ");     sql.append(this.tableName);     sql.append(" (");