8 Resources for

strsql

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Excel UPDATE to MS SQL having Run-time error: Hello All,I am very new to excel, VBA, and SQL although I have had programming experience, it has been a long time ago.I have created a form in excel to be an invoice. I have a MS SQL database that contains the customer info. I have completed the portion...; Tags: Sales strategy, Sales force management, sales, rtfentem@..., Microsoft Excel, strSQL, Sales Invoice, Worksheets; Discussion threads 2007-09-21
Acess VBASQL UPDATE STATEMENT ERROR: I am trying to update a table in acess 2000 n I keep getting a syntax error. Can someone please help. I have been looking at this for daysnot kidding. The only thing that I notice is that the compiler keeps changing some of my field names although they are...; Tags: acessvbasqlnewbie, strSQL, Me!; Discussion threads 2007-04-17
Build a data-bound grid with C# and ADO.NET: Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...; Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server; Technical articles 2006-08-30
Problem with SQL Query in Visual Basic: The following query works if I remove the "tblLocations.PrimaryFlag=-1" from the WHERE statement. I wanted to see if anyone could tell me what I am doing wrong. I have also tried "tblLocations.[PrimaryFlag]='-1'" and "(((tblLocations.PrimaryFlag)=-1))". I need to be able to filter for records with a -1 result for...; Tags: Microsoft Visual Basic, programming, SELECT tblCustomers.CustomerID, strSQL, tblLocations.PrimaryFlag, tblLocations.PrimaryFlag=-1, twhite@...; Q&A 2005-09-14
Displaying file properties from within VB6: over my headI liked the concept, but the description was far too deep into geekspeak for it to be usable for me. I don't do heavy programming in VB6, just complex macro work in XL. Would've needed to hold my hand, explaining each piece of the coding, for this to...; Tags: annmarie.cross@..., CStr, file properties, fMask, Long strSQL, lpVerb & vbCr, Microsoft Visual Basic 6.0, nShow, programming, ShellExecuteEx shInfo strSQL, String, String strSQL, strSQL, vb6; Discussion threads 2005-08-19

Which dataset should you choose?: The choice between untyped and typed datasets rests in the hands of the developer. Examine the differences between the two. I've recently noticed some confusion among coworkers and clients regarding dataset options. This confusion stems from the fact that a dataset may or may not...; Tags: Tony Patton, .NET, Programming languages, cntString, strSQL, dataset, Console.WriteLine, SqlConnection, Nothing, developer, .NET Newsletter, Microsoft Visual Studio, TechRepublic Inc., Database, Microsoft Visual Studio.Net, XML Schema, Class, Column, Dataset1, Microsoft Development Tools, XML, Development Tools, Software Development, Software/Web Development, Web Development; Technical articles 2005-06-28
Which dataset should you choose?: I've recently noticed some confusion amongcoworkers and clients regarding dataset options. This confusionstems from the fact that a dataset may or may not be typed. Thedeveloper makes the choice, which affects how the dataset isutilized in the code. In this article, I examine dataset types tofurther clarify their differences. ...; Tags: Dim cntString, dataset, cntString, strSQL, Tony Patton, Nothing, developer, SqlConnection; Technical articles 2005-06-28
Save time by using WordPad or Notepad for big SQL edits in Access 97: If you or your users use SQL to query Access 97 tables, Peter Nelson has a tip that's guaranteed to help save you time and trouble.Access developers aren’t born; they have to learn by paying their dues. One time-saving tip that I like to teach students who are on the...; Tags: Databases, Programming languages, Microsoft Office, Peter Nelson, strSQL, strDate, SQL, Microsoft Access, Microsoft Access 97; Technical articles 1999-11-23

Additional Resources

Somebody pls help!!!!!! MS Access/VB6.0 query problem: Can someone help me pls. I'm developing an application for my small travels and tours agency that will handle the personal information and reservation requests of customers. I want a situation where when I click the view reservations button from within the customer page, the "Reservation form" will load and...; Tags: Programming languages, Scripting languages, Databases, Microsoft Corp., deyshele@..., reservation, Dim strSQL, cusIdNum, customer id, CusIDval; Discussion threads 2007-09-16
About sql server 2k trigger/procedure: When a table is modified, I want a trigger to export the data of table to a file,such as *.txt or other. I have tried to realize that by using following codes, but failed. create trigger tr_ActionLog on ActionLog for update,insert, delete AS SET NOCOUNT ON --declare @strSql varchar(255) exec dbo.ExportData2Csv 'liulzh',...; Tags: Databases, @strSql, ActionLog; Q&A 2005-06-01
Upload .xls file to SQL Server table w ASP.NET app: Here's what I have to do: 1. Allow user to locate a .xls file on their machine 2. Upload this .xls data into an existing table on a remote SQL Server I can pull the file from my local machine to another directory on the local machien, but...; Tags: chip@..., database, Dim strSQL, Label2.Text, local machine, Microsoft ASP.NET, Microsoft SQL Server, programming, server, software; Discussion threads 2005-08-09
strSQL = "Insert into ActivityTest Select * FROM OPENROWSET": can u explain this,plz; Tags: mail2aashutosh@...; Discussion threads 2007-04-01
Problem with MS Access 97 SQL query.: Can someone help me pls. I'm developing an application for my small travels and tours agency that will handle the personal information and reservation requests of customers. I want a situation where when I click the view reservations button from within the customer page, the "Reservation form" will load and...; Tags: Databases, Microsoft Corp., deyshele@..., Microsoft Access, reservation, customer id, cusIdNum; Discussion threads 2007-09-12
Adding items to the subitems in a listview in VB 2005: Hi thereBelow is some of my code in VB6 that use to add items to a listviewwith subitems:The listview is called lstvCustomers that gets data from a Access DBI know how to access data from access and I know how to add the datain the 1st columnmy problem is adding...; Tags: Microsoft development tools, Programming languages, rieda@..., SubItems, listview, Dim strSQL, VB 2005, Microsoft Visual Basic; Discussion threads 2007-05-10
MSAccess Refresh Active record: Hello all. I would like to ask if anyone knows how i can refresh my form without the focus being changed to the first record, essentially refreshing the form and subform while keeping my cirrent record as the active record.I am entering data into a form, I have a command...; Tags: jim@..., Dim Buckets; Discussion threads 2007-07-17
Combo Box Trouble: Hi guys,Here is code I am using to populate a combo box from the table. Set cnnConnection = CurrentProject.Connection Set rstRecordset = New ADODB.Recordset strSQL = "SELECT * FROM Country ORDER BY Country" rstRecordset.Open strSQL, cnnConnection, adOpenDynamic, adLockOptimistic...; Tags: carterlangley@..., id; Discussion threads 2007-04-02
how do i use rs!field in vb.net: is there anyway i can use rs!field (ex: rs!customer_id) in vb.net.when i code it in VB.netdim str as stringset rs = new adodb.recordsetdim x as singlestr = "select customer_id from person"rs.open str, dbconn, 3,2x = rs!customer_id ''' this is error it says to many arguments..how do i solve it in...; Tags: Console.Write, DataReader, Dataset, Dim strConn, Dim strSQL, Microsoft ADO.NET, OLEDBCommand, OleDbConnection, plr007, programming, ToString; Q&A 2005-05-04
VB.NET Access DB DataSet problem: I'm developing a VB.NET 2005 application with an MS Access backend. The Queries for the most part are "LIKE" queries, and they will not return rows in the application when querying in Access I return rows. When I run a "=" query I return rows from the application...; Tags: Microsoft Office, Databases, Programming languages, .NET, culbysl@..., Microsoft Access, Microsoft Visual Basic.Net; Discussion threads 2007-09-01
How do I... Dynamically fill Microsoft Word fields using Access data?: This blog post is also available in PDF form as a TechRepublic download. The download includes a sample Access database and Word form.Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame....; Tags: Microsoft Word, Microsoft Access, Data, Field, Microsoft Corp., Form, Susan Harkins; Blog posts 2007-08-23
VB code office 97: I am new to a company and they have a program written in office 97 and we want to change the code so it is written in office 2003. It crashes if the end user does not have office 97. I am networking guy so I am not sure how...; Tags: Fax, Microsoft Visual Basic, bsl@..., F24, F23, F17, File1.path, F18, F19, StatusList.AddItem InputFile, FileFromCommerce.Text, StatusList.AddItem, F22, Input #1; Discussion threads 2007-07-25

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (3 results)

Q&A (1 results)

Technical articles (4 results)

Quick Guide: Windows Group Policy: One way for help desk technicians and network administrators to reduce help desk calls and protect their networks is to limit the damage curious users ...; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now