Apologies if the title is a bit abstract, but it was hard to put into a single title what I am trying to achieve.
I have a table called PTYP and columns named PTYPNR, STAB1, STAB2, STAB3.......to STAB10
In some of the records one of the STAB columns (could be any of them) can have an entry of 1659 what I am trying to do is delete this entry but then move the values in the columns to the right 1 to the left
...
Dellboymash
Last Activity: Feb 26 '09, 06:27 PM
Joined: Feb 17 '08
Location:
-
Moving Data from right to left SQL
-
Simple VB 2008 Question
Apologies, I have posted this question before, but am still looking for an answer, and have therefore rephrased the question.
Users enter data into the database using a windows form. I am happy I have this working and can create records in a SQL 2000 database fine
However there are some fields that have a default value that the user doesn't need to enter, but I want them to be included in the database record they are... -
I have looked at your response and am unable to work through it. I am not sure that it answers my question.
All I want to know is what the syntax is for making a field in a dataset = a value.
i.e.
I have a dataset call employeesdatase t
within the dataset is a table called employees
within the table is a field called hotel
I want to set the value of this field (within the current... -
Thanks for your quick response. I am leaving fior teh airport in an hour, so will look at it on my return
Many thanksLeave a comment:
-
Example code here
http://www.vb-helper.com/howto_dec_hex_o ct_bin.htmlLeave a comment:
-
Vb 2008
Apologies if this is a basic question but I am a newbie to VB. I have tried many searches but find it difficult to find a fitting answer.
I am creating a VB 2008 project with SQL 2000 back end.
I have a data source setup, table adapter etc and have populated a form with various fields from the dataset.
I can add records to the DB no problem, however:
What is the correct VB 2008 syntax to... -
Spot on
Thanks very much for your help. I had spent two weeks trying to get my head around this before you response.
You solution works perfectlyLeave a comment:
-
Thanks for the quick response. I have also tried adding a join from the Room table [Room Night] and Events Table [Events_start_da te], but this will only return matches where both dates are equal (obvious!)
To briefly explain. The events table shows events that happen during a booking e.g. Lunch, Dinner, etc. the Rooms table shows the nights guest are staying.
Invaribly guests stay the night before any events happen....Leave a comment:
-
Problem with a select statement
I am setting up a view that pulls from two other views. I want to return the records from both views based on 1 common field but I end up with the Catesian product of these records
There are two valid records in each table
...Code:SELECT dbo.Delphi_Forecast_Rooms.BUS_ID, dbo.Delphi_Forecast_Rooms.[Room Night], dbo.Delphi_Forecast_Rooms.Singles, dbo.Delphi_Forecast_FB.[Booking ID], dbo.Delphi_Forecast_FB.Event_Start_date,
No activity results to display
Leave a comment: