VB Forum / Database Access / January 2005

So far I have been doing tables for web page with only the html tags
associated with <table>.  Please click the following page for an
example:
http://www.pinyinology.com/meridians.html

I want to execute an update to SQL on a single line and I can't remeber how.
It seems that it was something like this:
Conn.execute "UPDATE table WHERE field = xxx
(fld1,fld2,fld3)value(val1,val2,val3)"

I have a stored procedure I want to run several times in
the same routine.  Below is how I am calling the stored
procedure.
How can I run the stored procedure the second time with

i am a begginer to VB, and am learning how to implement a database into VB.
i want to run a simple database in VB, and edit and delete records using VB.
i know i have to link the database using ADO's, and create a simple form
that will navigate and edit the records.

This application is VB6 using SQL Server - when trying to run a click a
button to run an update command the following error is displayed:
"Application error -2147217833 String or binary data would be truncated"
and then

Hello --
Can anyone tell me one or more sources of examples of using ADO Data Control
and DataGrid control?
I am struggling with even the simple task of displaying data from the pubs

I just try to create a system under the VB .net with teh ADO .net. I found
that i need to create a sqlconnection in each form. They all have the same
connection string (connect to the same database). Is any way to create one
connection and it work for all form?

I need to create a transaction for confirming data written to an Access
database. However, how would one code it over a number of subroutines? not
just the a single one.
Cheers,

  I'm working with very long queries for insert, update and select, and
having a lot of troubles about updating data as some fields are very
large text ones. The problem is VB is cutting down my SQL-query string
so it doesn't work.

Hi
Im trying to write sql queries in class modulas that are triggered by a date,
ive tryed inserting a date into a veriable both string and date ive encased
it with # and with out.

I'm trying to write a utilities module for my project.
I want the module to contain a function to accept a SQL statement as a
parameter and return an ADO recordset object.
Everything works fine until I try to return the recordset to the

I'm trying to write a utilities module for my project.
I want the module to contain a function to accept a SQL statement as a
parameter and return an ADO recordset object.
Everything works fine until I try to return the recordset to the

Can someone point me in the right direction?
I have a web site which uses a MySQL database to store items for sale,
client information and credit card info etc (or will be soon).  I'm
currently looking at building a back-end website to control all this

The Script below is working fine. Can anybody convert these script so that
it will work from VB Form with a Command Button?
Script: Author: Vasu
 Dim OBJdbConnection

I am trying to run a data report using the DataReport Designer in VB.
When I run it I get  "Failed getting rowsets from current data
source".
Can I look at the SQL statement that this report is generating and