Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
Are there non-usable column names?
Name: mking (by mkingrey) Date: September 28, 2005 at 11:11:09 Pacific OS: XP CPU/Ram: 1.4 ghz
Comment:
I ran into something interesting when querying an Access database from a vb.net webform. I had two columns one named "Time" and one named "Open." I could not use the INSERT clause until I changed the name of the columns in the databases. Has anyone ever ran into something like this before?
Name: StuartS Date: September 28, 2005 at 11:35:41 Pacific
Reply:
I have comes across the problem with Time. It is because Time is a function within VB for Applications, the programming language used with Access. You will get the same problem with Date.
I imagine that the same applies to Open as Open is a function within VB for Applications.
Stuart
0
Response Number 2
Name: SN Date: September 29, 2005 at 12:43:34 Pacific
Reply:
I've run into it in mySQL with a table named 'Order'...You should be able to workaround it by specifying the table...ie 'SELECT * FROM tablename.Time';
Summary: Hi guys Can you please tell me what script to write in a batch file so that it adds column names to a .csv file. So for example I have a file now that comes through as: 1 2 1 3 2 4 but I want th...
Summary: DBMS: SQL Server Hi, I need to rename all columns, stored procedures, triggers, and references to each, in order to ensure the names are under 30 characters. I will need to: 1) locate all objects cont...
Summary: select empname,sal from emp where sal in(select max(sal) from emp); subquery. It will list out all the employees who are getting maximum salaries. Dept Table-Deptno &Deptname Emp Table-Empno,Empname,D...
0 
Copying Batch to another ...
