by: James_101 |
last post by:
My training piece is in Authorware. The user logs in with last name and a
four-digit number. Authorware sends this user identifier to an asp page
called db_read.asp. This file sends a SQL SELECT...
|
by: Santosh |
last post by:
Hi,
I have a script running which fails when it tries to execute an Update
query, but when i try to run the query from the SQLQueryAnalyzer it runs
fine.
Can somebody try and explain this...
|
by: rdraider |
last post by:
I am looking for some assistance with an update query that needs to link 3
tables:
This query ran and reported over 230,000 records affected but did not change
the field I wanted changed, not...
|
by: John Baker |
last post by:
Hi;
I am have a db back end situation, and have a problem with temp files. I am attempting to
use temp files to manage the modification of a master file, and its not working right.
I set up...
|
by: Greg Strong |
last post by:
Hello All,
Is the only solution to an update query which requires the records in a
certain order to dump the records into a temp table in the required
order, then do the update query?
I've...
|
by: rdraider |
last post by:
Hi all,
Any thoughts on the best way to run an update query to update a specific
list of records where all records get updated to same thing. I would think
a temp table to hold the list would be...
|
by: Keith Wilby |
last post by:
A2003.
If I use a linked table (linked to a CSV text file) in an update query I get
a "linked tables cannot be updated" error. What the? The CSV data is the
*source* data and I'm not...
|
by: yuva17raj |
last post by:
hi
i am trying to update my sql table data with the csv/excel file data
my sql table is as follows
test test1
23 usd
25 ero
34 test
and my csv file has
|
by: gagandeepsngh |
last post by:
'Code for selecting a particular data from database
'***** START *****
sSQL = "SELECT name FROM trans"
cmd = New OleDbCommand(sSQL, con)
Dim reader As OleDbDataReader = cmd.ExecuteReader()...
|
by: Alexis Ellis |
last post by:
I am using adodb in python to connect to a database and run sql queries.
I run several update queries in a table.
Then I do a 'Select Into' to copy the table to a new database.
All of the updates...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|