Solved

SQL validation program for Cisual Basic 5.0

Posted on 1998-11-25
3
186 Views
Last Modified: 2010-03-19
I need a validation program from SQL that works on Visual Basic 5.0 with the codes that it has.
0
Comment
Question by:delganic
  • 2
3 Comments
 

Author Comment

by:delganic
ID: 1091986
Adjusted points to 20
0
 

Author Comment

by:delganic
ID: 1091987
Edited text of question
0
 
LVL 1

Accepted Solution

by:
Eklipse earned 20 total points
ID: 1091988
Please be a little more specific
Look a this code
I supposse that you have a public Database called DB already open
function ValidateSQL(SQLString as string) as long
Dim r as recordset
On error goto VError
Set r=db.openrecordset(sqlstring,dbopensnapshot)
ValidateSQL=0
r.close
Exit sub
VError:
ValidateSQL=err.number
end sub

This simple program returns 0 when success,else returns a code error

It could be a very simple method to test validate an sql string
,but I guess that you are looking something better.

Greetings
Fer

0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now