Search results

It's an Oracle environment, a data warehouse, I'm just trying to make a table with a auto number primary key. Sorry I'll try to post this on a SQL specific forum. Thanks for your help though.

I'm trying to make that field an auto number but haven't been able to figure it out. How do I make it an auto number? Other then that thanks for your help, very appreciated.

When I run this code to create a table with a PK I keep getting this error on the line where I have my contraint. Adding another parenthesis does not help. SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" Any help is appreciated, Thanks!! CREATE...

Solved! Thanks!! You are correct I didn't have the primary key in the query I was using so it was looking at the persons name. I added in the primary key and it works.

I’m trying to set up a pop up window for quick viewing by double clicking a listbox value. I’m having trouble finding the selected value (Primary Key) and feeding it to the popup form. In the bolded code below "output_window" is the listbox. Error: Property let procedure not defined and...

I figured out the problem. I had my txtbox call in the wrong place, the code works below. Do While Not rs.EOF Me.txtCFS.value = rs![CFS] rs.MoveNext Loop How do I get it to call the most recent record?

Run-time error 2113 The value you entered isn’t valid for this field. The txtbox is unbound so I don’t think that’s the problem. The field value CFS in the table is a date and I’m setting CFS as an object so this is where I’m guessing things are going wrong. I can't set CFS as a date the way...

I'm running the query below to get a list but when I add the date function I get this error. The date function is supposed to get all the records that have been added in the last month. ORA-00936: missing expression 00936. 00000 - "missing expression" *Cause: *Action: Error at Line: 25...