by: Jim Hatfield |
last post by:
I'm using: "select min(objid) from table_name where objid > $objid"
to select the next row in a sequence where there may be gaps. It
works fine unless the where clause results in an empty set.
...
|
by: jallegue |
last post by:
I am working with MS-Access 2002. The two tables that I am working with
are:
dbo_IDX_FRS_account_bal_by_month ==> this is a linked table to SQL
== local table
The query that is executed is...
|
by: Mr. x |
last post by:
Hello,
I have hosted my site in an hosting server.
I got the following message, while trying inserting a record to the database
:
Operation must use an updatable query.
For what I know, I...
|
by: Jim |
last post by:
I'm trying to develop an Internet application using an Access database, and
I'm trying to insert records using an insert query. I keep receiving an
error stating that I need to use and updatable...
|
by: cyber0ne |
last post by:
I'm having a bit of trouble adding records to a local .DB file (using a
Paradox connection string). I checked the file permissions, and for
testing purposes set Everyone to Full access. But it...
|
by: Enrique Rojas |
last post by:
Hello I have this sql that triggers the abovementioned error.
UPDATE ra SET ra.Year_1_Cost = (SELECT sum(conversion*Year_1_accom) AS
year1
FROM accomfundlevels
WHERE driver_id=168 And...
|
by: Ranjan kumar Barik |
last post by:
Hello everybody !
I am trying to insert into an access table using ADO in ASP. But i am getting the error message: "Operation must use an updatable query".
I have checked the security settings...
|
by: anniebai |
last post by:
Can someone help me with this query, which gives the error message "operation must use an updatable query"? Thanks a lot.
UPDATE publications set publications.pmcid = (select fname.pmcid from fname...
|
by: geolemon |
last post by:
I'm trying to perform an update, and I can't avoid this error - I've tried this query what must be 5 different very fundamentally different ways now.
Arg.
I used to be a DBA in large DB2 and SQL...
|
by: franc sutherland |
last post by:
Hello,
I am using Access 2003. I am having trouble trapping the "can't
append all the records in the append query" error message when
appending data to a query from a table which is linked to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|