sql

I have an SQL query which was provided by one of the forum members which works fine.. I need to enhance this by making 2 literals which are part of the SQL query as variables. ' sqlSelect1 = "SELECT L_CALL, L_QSONR FROM LOGBOOK WHERE L_CALL = @callsign AND L_DATE=...

Hey guys, so I have a bit of problem regarding my current coding within my project, this issue being that I am struggling to get this code to run when trying to update an already existing record within an Access database, any assistance given would be highly appreciated...

I am currently going through a tutorial book called Visual Basic and Databases by Philip Conrod and Lou Tylee. I am doing well with it and learning a lot from it. However, I have got to a point where I can not figure out what my computer is doing. I am trying to create a database using the...

If I am posting this is the wrong area, I apologize. I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...

Hello people. I have been struggling for some time now with drawing up a relationship diagram module for my scenario. I have three tables as of now. 1) Recipes 2) Ingredients 3) RecipesIngredients Recipes --(one to many) ---|> RecipesIngredients <|-----(many to one) --- Ingredients...

So below is the code I wrote yesterday. I don't often work in VB and I haven't had to insert a BLOB before. However, the error at least at this moment isn't BLOB specific but syntax. I'm getting the error from Oracle - 'Missing expression' I can't see what's missing but honestly I've been...

Dim db = New database Dim dt As New DataTable With db .sqlStr = "Select itemprod_id as ProductID, item_name as BrandName, item_description as ItemDescreption, company_id as Company, quantity_stock as Stock, stock_alertcntr as alert, wprice as CompanyPrice, price as RetailPrice...

I have a dialog I wrote which is nothing more than a SQL server / database selector. It provides a graphical interface for a user to select their SQL server, database and authentication methods. Anyway, this worked fine prior to moving to Windows 10. Since moving to Windows 10 I'm unable to...

In Studio Express 2015 i get decimal with "." but in MySQL i get it in "," Hi All! I am writing an application where i can calculate different prices, but i hit a barrier. When i read values from the database they are displayed like "1,6" but when i convert it to Double to get another value...

I am using a tableadapter to query a database using ODBC. The query is being created by the VS2015 Query Builder. If I make the SQL statement with a variable parameter then the result comes back blank. If I replace the parameter (the question-mark) with a hardcoded parameter then the result...

Hi Guys, I have a question about .net programming, this is what i have to do i need to build a cashier app and this app have connection with sql server at other place, so the main point is can i keep the thing that have been sold when internet down, and when internet up its automatically...

I am building a VB.NET Windows Application form, and as a newbie cannot figure out an issue. I have two sql tables, which are not joined. I wish to update one (skedulering) from another (ontledings) where I have certain "WHERE" clauses as in the following code : opdraginvoer.Connection =...

Hi guys I am designing a simple windows form application using typed datasets. My requirement is to assign a sequential value from a database SEQUENCE to one of the textboxes available with the form while default navigator "Save" button is clicked. My Database level Sequence name is...

I have this database driven menu for a client, I don't remember why I set it up like this, but now they want a change that I can't seem to implement. Here's the code: Sub PopulateMenu() Dim dst As System.Data.DataSet = GetMenuData() For Each masterRow As System.Data.DataRow...

Hello, My aim is to export data from my SQL database into a word document. I have managed to export data into the word document from my database however if I was to go back onto the word form and type another service ID from the database and click export to word document it would export the...

I really am trying to figure this out but just cannot get it right. I have 2 tables, "tblSalesMain" and "tblRepMain". I am trying to return to a combobox a reps first and last name instead of an "ID". For example, when a sale is selected it will show all of the info of the sale in different...

Hello Community, I currently has a cluster of example code that I would like to combine. My current challenge is inserting a string from my GPIB bus into my SQL Database field. My working code looks something like this: Dim vpp1 As String vpp1 = GpibDevice.ReadString() MsgBox("Current Voltage...

I had a vb.net application with database connection. I am using Microsoft visual studio 2010 for developing windows application and Microsoft SQL Server 2008 for database access. My question is how to deploy the application and how to install it in other computers. I've tried a step but when...

Hi all, Maybe You will find a solution - how to save (insert into statement) multiple textboxes in one column in SQL table? Well, what I have is a winform with 20 textboxes (each is for one metric). Table is build like: Team | GSDate | GSGroup | GSMetric | GSValue |...

How to import data from excel xlsx files to sql database if in some files the row and content of the headers are changing (even if they change they point the same data, see example)? I work in Visual basic environment with VS 2012 Here is the example: The problem is number of headers are...