?
Solved

SQL validation program for Cisual Basic 5.0

Posted on 1998-11-25
3
Medium Priority
?
216 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 80 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

621 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