Hi Experts,
I am making a VB application in which user will type SQL query in Rich Text Box. I want SQL verbs/syntax automatically change color after typing. For example if user types
SELECT ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20258819.html
Zones:
Visual BasicDate Answered: 09/23/2002 Grade: B Views: 4
Dear experts,
I don't understand why there is a syntax error in my SQL. PLS ADVISE!
strSQL = "INSERT INTO Transaction(name, amount,date, beg_Bal,end_Bal, type, memo) values (" _
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20597369.html
Zones:
MS AccessDate Answered: 04/28/2003 Grade: A Views: 0
Hi,
We have a table in our database called 'Filter' and this is used as part of an application. Table e.g:
FilterNo Descript ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20880905.html
Hi!
I believe I ahve a very simple question abour Remedy application access through Remedy client to read and write to the the database.
The first question I have, is Remedy Database complete...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21183326.html
Zones:
DatabasesDate Answered: 10/28/2004 Grade: C Views: 0
Hi, I believe I need some help on this one.
SELECT dbo.ProjectLines.OldHALNum, dbo.ProjectLines.VendorCode, dbo.ProjectLines.Description, dbo.ProjectLines.ExtendedDescription,
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21268651.html
Zones:
DatabasesDate Answered: 01/25/2005 Grade: A Views: 0
Hi - I have a sql script that is fairly basic in that it selects data from a couple of tables an d gets outputted into a users excel sheet.
This normally works fine until we find that sometimes t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21273733.html
I have a table with the following data
product cost adjustment quantity
parta $1 10
partb $2 5
partc ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21310904.html
I am trying to close to hard code a value into a column however I keep getting syntax errors when I erform my INSERT.
Here is the end of my SQL: I need to insert the value qryCockpit into the dat...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21450099.html
Hi All!
In a VBA program, I'm retrieving data from a database into an ADO recordset.
The database is actually an Oracle DB, but I guess the SQL syntax for this is the same in SQL Server, so I a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21571595.html
I am creating a view, and I would like to create a new column that is made up of the data from 2 existing columns, plus some text of my own. Here is an example:
There are the following columns in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21646723.html