python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - adodb

Excel VBA ADODB query not able fetch specific date

I am getting empty recordset when i try and execute the below query: Mnbtquery = "SELECT * FROM [Sample Proposal List - 2021$A6:AB170] WHERE [PROPOSAL SUBMITTED DATE]= #31/1/2021#"
test-img

venom181

sql

excel

vba

adodb

Votes: 0

Answers: 0

SQL Visual Fox pro 9 - After inserting record some chars code are changed in database (e.g. "À" => "A")

I am connecting to Visual FoxPro 9 SQL database and I need to be able to update and insert records in a table. The table I am trying to work with has column with type CHAR(5). The problem is that some...
test-img

Filip Kasarda

sql

database

adodb

visual-foxpro

Votes: 0

Answers: 1

Latest Answer

If it works from the UI then please look at the Code Page used in the UI (see function CPCURRENT() in the help) and use the same Code Page in your VFP OLEDB connection string - add CODEPAGE=nnnn into ...
test-img

P.C.

Writing from a WinCC recordset

I have a working script that reads WinCC DB and writes data into a CSV file with two columns (1 timetag and 1 value). path = "C:\HMI\Report\Report.csv" 'creating csv file Set fso = CreateObj...
test-img

Aleksandr

vbscript

adodb

wincc

Votes: 0

Answers: 1

Latest Answer

A little long text, sorry about that and I also like to keep the query simple. No need to make things complicated. First something about “WinCC Connectivity pack” you are using: “Licensed access to on...
test-img

Per Dahlqvist

MS Access and MySQL attempting to change the same record

This is an old issue in stack overflow, and i have tried all of the suggestions I can find. Mysql database linked to ms access. Windows 11 - new laptop ms access database app that i have been carryin...
test-img

Paul T.

mysql

adodb

Votes: 0

Answers: 2

Latest Answer

While not a direct answer to your question, I feel like this logic can be handled with a single UPDATE statement in mysql directly. Something like: WITH updateCTE AS ( SELECT DailyTaskID, C...
test-img

JNevill

Posts

Questions

Blogs

Jobs