Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Add field to recordset VB6

Comment:

Is there a way to add a field to an already defined recordset at 'RUN-TIME' using VB6? Thanks, Global

Name: Chi Happens
Date: June 13, 2003 at 19:21:09 Pacific

Reply:

If you want to add a field to the database table? You need to use an ADODB.Connection object and the SQL command ALTER TABLE Like this: Dim ConnString ' Connection String Dim CN As ADODB.Connection Set CN = CreateObject("ADODB.Connection") ConString = [Connection String] - You have to type this in, it can be a DSN entry or a complete connection string. CN.Open ConnString SQL = "ALTER TABLE MyTable ADD COLUMN NewField c(20)" CN.Execute SQL CN.Close Set CN = Nothing

0

Free XML Parser for C++, ...

Protected Updater

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: You just can't add text to a jpg image. 1 - uncompress the image. 2 - to create the text image. 3 - Overlay text image over jpg image 4 - recompress to jpg. A Perl script calling other programs could....

Summary: I have problem to install VB6 Enterprice to winxp pro sp2 / AMD pc, setup informs install was not completed. It works, but I can't use all the components, like msflexgrid. I can install it to two othe...

Summary: Hi! does anyone know how to use/add color to your graphics? ex: red and white checkered board or something ...