Search results for query: *

Hi everybody! strSQL = "UPDATE Tools SET Description = '" & tool_desc & "', Price = '" & tool_price & "', Bought = '" & tool_bought & "', Company = '" & comp_name & "' WHERE ToolID = '" & tool_id & "';" cnSQL.Execute strSQL I try to execute this and always get the same error "To few...

Hi, I am trying to connect to a SQL Server using VB6. I have put in name of server and the initial catalog (the name of database I wish to use - this is right isnt it???) But I am having trouble logging in. Is there a way I can instruct it to login using my Windows authentication, without...

Hi everyone, I have an Access 2000 form. I add an item to a table then refresh the form hoping the changes would be reflected in the subreport I have set up to show table contents. I dont have any of the wizards running so I have hard coded pretty much all of this. The problem is when I...

Doesnt matter got it sorted. Thanks anyway.

Hi, I am running a proc in which an INSERT .. SELECT is fired off. One of the columns I am inserting to is of type TIMESTAMP. The value I am inserting is CAST(CURRENT_TIME(2) AS TIMESTAMP(2)) But I keep getting an error back SPL1027:E(L282), Missing/Invalid SQL statement'E(5407):Invalid...

Hi, I am running a REPLACE PROCEDURE. In the procedure I create a number of VOLATILE TABLES. The syntax looks correct to me but I get an error saying "User is not authorized to use the DDL/DCL/Dynamic SQL statement" Logged in as Admin too. Cant for the life of me figure this out, anyone got...

To get the TOP 20% of rows according to your WHERE clause it is SELECT TOP 20 PERCENT stores Just new to TD but I think this should give you what your after

Hi, I have my rs all set up and full of data but cant get more than one item into the checkbox. While rs.eof = False cmbTools.Value = rs("ToolID") rs.MoveNext Wend I know this doesnt work but Im used to VB6 and cant find the AddItem or a similar function here. Thanks for the help!

Hi, I am working with an Access database, and cant find the datareport designer in VB.Net, probably because there isnt one. Can I open a report from the Access database using VB.Net? Cheers, Gerard.

Hi all, Was hoping someone could point me towards a Teradata tutorial or a site explaining what it is and what it does? Work are changing from SQL to TeraData - hoping to get a heads up. Any help offered is gratefully recieved. Cheers, Gerard.

Sorry its in my module: Imports System.Data Imports System.Data.OleDb Imports System.Data.Odbc Imports ADODB Public Class Form1 Inherits System.Windows.Forms.Form Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private Sub Form1_Load(ByVal sender As...

D'OH Cheers for that! Now to problem two: (This is a module) Imports System.Data Imports System.Data.OleDb Imports System.Data.Odbc Imports ADODB Public Class Form1 Inherits System.Windows.Forms.Form Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader...

Hi, I am saving a record and trying to update the data in the datagrid, BUT alas things are not running smooth and I havent learnt all the errors yet. Heres my code Dim da As OleDbDataAdapter Dim dt As DataTable Dim cn As OleDbConnection Dim cmd As OleDbCommand...

Hello, Again the switch from VB6 to VB.Net is giving me problems. I was wondering how I could export a RecordSet and enter it onto an Excel Sheet. A link to a tutorial or any code you have would be appreciated. Thank you very much.

Hi, I am tying to access a datagrid from the module but I am having problems. I have tried just dgTools.DataSource = dt but no go. I have tried Form1.dgTools & Form1.Controls(dgTools) Im too stuck in my VB6 ways. Any help as always is greatly appreciated.

Cheers lad you have been a great help! But I cant get an answer to this anywhere: Does VB.Net have a version of the DataReport Designer you got in VB6? I bought the single VisualBasic.Net package not the entire Visual Studio.Net.

This brings up an ADODB problem, and where you specify the source Table, I am selecting using a join so would have specify two tables.

I had a small runtime error that wasnt stopping it playing, however once I fixed that the changes popped up straight away - WEIRD! cmd = New OleDbCommand("INSERT INTO Tools (ToolID, Description, Price, CompanyID, BoughtDate) VALUES ('" & varToolID & "', '" & varDesc & "', '" & varPrice & "', '"...

Actually I have noticed a different problem. I have changed code and the design of my form but these changes seem to be lost at Runtime. I have added textboxes that dont show up. I have changed format of DataGrids but the changes have not appeared. It seems to be running the form design as it...

Hi, I have a form with a DataGrid showing the contents of Table1. Below this we have text boxes for entering Data into Table1, when I click the Save button I execute the INSERT statement and then DataGrid1.Refresh() - Doesnt show the new Information Set up the datasource again - Doesnt show...