SQL COMMAND PROBLEM?!?!?
-
I want to find a certain record in my database. The search Criteria comes from text1 This is what I thought it wuold be:
select LASTNAME, FIRSTNAME, DOB from dc where LASTNAME = text1.text
This doesn't work. Can you please help. -
Here is how it works:
"SELECT A, B, C FROM Table1 WHERE A = '" & Text1.Text & "'" -
I tried what you said but I couldn't get it to work. I just got errors this is what I typed in.
data1.recordsource = "SELECT * FROM Titles WHERE PubID = '" & Text1.Text & "'"
I wouldn't work. Can you tell me what I'm doing wrong? -
I tried what you said but I couldn't get it to work. I just got errors this is what I typed in.
data1.recordsource = "SELECT * FROM Titles WHERE PubID = '" & Text1.Text & "'"
I wouldn't work. Can you tell me what I'm doing wrong? -
What error are you getting?
-
The Error I get is the following: "Data type mismatch in criteria expression."
Can you help? -
PubID wouldn't happen to be an integer, number or AutoNumber field type?
-
Yes its an integer. Does this make a diffrence?
-
Try to remove the single quote...the single quote is for text and date data type.
Post a reply
Database forum discussion
-
Required Every quarter data from sql automatically in below sql format
by jain.piyush831 (0 replies)
-
Is Your Data is Lost? Learn Online How TO Recover Your Data.
by dataempires (0 replies)
-
Executing a command line SELECT
by cyoung311 (0 replies)
-
Softaken Mac OLM to PST Migration Software
by albertcolin012 (0 replies)
-
MAX value of each column - HELP
by triparipr (0 replies)
Quick links
Recent activity
- arif ahmad replied to How to receive data in web ...
- William Thompson replied to What is the name of the Win...
- Sameera Piyadigamage replied to Point of Sale Developers: H...
- Scott Carline replied to 4 x C# Developers for large...
- Rajendra Dhakal replied to Restore SQL Server text dat...
- cloud rainda replied to How to convert between TS f...
Enter your message below
Sign in or Join us (it's free).