@Bisonte: I knew that OpenDatabase() was not enough but never thought to get the schemas to be 100% sure.
Thank you both for your replies!!
Search found 853 matches
- Sat Apr 13, 2024 1:06 pm
- Forum: Coding Questions
- Topic: Deletefile() not working?
- Replies: 4
- Views: 224
- Sat Apr 13, 2024 11:13 am
- Forum: Coding Questions
- Topic: Deletefile() not working?
- Replies: 4
- Views: 224
Deletefile() not working?
I have the following code that tries to check if a file is a valid database. If so, it loads it, if not, it replaces it with a valid one. I tried with a renamed random txt file to see what happens. The code detects that it is not a db but seems to fail to delete it. DeleteFile() returns zero, OpenFi...
- Mon Mar 11, 2024 9:24 pm
- Forum: Coding Questions
- Topic: Help with Query
- Replies: 4
- Views: 234
Re: Help with Query
No working code... no help. I understand that I forgot to mention it is an SQLite db.I have problem with the query so I don't think that a working code is needed. I just posted the query that returns data in wrong order. I apologize for any inconvenience. After all, DarkDragon managed to find the s...
- Mon Mar 11, 2024 6:13 pm
- Forum: Coding Questions
- Topic: cannot read specific xlsx files
- Replies: 3
- Views: 263
- Mon Mar 11, 2024 12:53 pm
- Forum: Coding Questions
- Topic: cannot read specific xlsx files
- Replies: 3
- Views: 263
cannot read specific xlsx files
Some days ago I found a code here in this forum that reads xlsx files. It reads many files like a charm but I have some files that cannot be read. I do not know the original author. Can anyone help? I can send a sample file with PM. ;original idea from Mijikai, thanks for that! ;https://www.purebasi...
- Sun Mar 10, 2024 8:41 pm
- Forum: Coding Questions
- Topic: Help with Query
- Replies: 4
- Views: 234
Help with Query
CREATE TABLE Lendings (book_id TEXT, stud_id TEXT, LDate DATE, Returned TINYINT, RDate DATE) CREATE TABLE Students (id TEXT PRIMARY KEY, Lname TEXT, Fname TEXT, Class TEXT) when I run: Select * from (select id, Lname, Fname, Class from students where id like '2023-2024%' and class = 'A2') S left jo...
- Sat Mar 09, 2024 9:41 am
- Forum: Off Topic
- Topic: Problem with SQLite query
- Replies: 3
- Views: 425
Re: Problem with SQLite query
I have: CREATE TABLE Books (id TEXT PRIMARY KEY, Title TEXT, Writer TEXT, Publisher TEXT, Year INT, Copies TINYINT, ISBN TEXT) CREATE TABLE Lendings (book_id TEXT, stud_id TEXT, LDate DATE, Returned TINYINT, RDate DATE) Your query returns the same error. On the other hand, select count(*) from books...
- Fri Mar 08, 2024 10:44 pm
- Forum: Off Topic
- Topic: Problem with SQLite query
- Replies: 3
- Views: 425
Problem with SQLite query
I make an app that handles school library. I try to run the query: Select L.book_id, B.Title, count(*) from Lendings L left join Books B on L.book_id = B.id where L.stud_id like '2023-2024%' group by L.book_id order by count(*) DESC and I get error: near "(": syntax error The exactly same ...
- Sat Mar 02, 2024 6:18 pm
- Forum: Coding Questions
- Topic: Ckeck if Excel is installed
- Replies: 2
- Views: 177
Ckeck if Excel is installed
I make an app that uses vb script to read and save Excel files. I want to know if excel is installed, if not, my app will not try to read or write. If it is installed, I want to know the version to be able to save xlsx files if version is 2007 or higher. (Yes, a client may have 2003 or earlier versi...
- Tue Jan 23, 2024 11:08 am
- Forum: Coding Questions
- Topic: read excel .xlsx file data ...
- Replies: 30
- Views: 4446
- Mon Jan 22, 2024 11:09 pm
- Forum: Coding Questions
- Topic: read excel .xlsx file data ...
- Replies: 30
- Views: 4446
Re: read excel .xlsx file data ...
Tested HeX0R's code and work just fine. Is there a way to read xls files too?
- Tue Jan 09, 2024 9:39 pm
- Forum: Off Topic
- Topic: .htaccess issue
- Replies: 3
- Views: 991
Re: .htaccess issue
...... send me a private message if you have any questions. Norm. You have a pm. The rewrite seems to be correct. Maybe a server configuration issue? redirect 301 rules work like a charm but no RewriteRule seems to work. What configuration could be done in plesk? (Plesk is the only tool that I use ...
- Tue Jan 09, 2024 5:49 pm
- Forum: Off Topic
- Topic: .htaccess issue
- Replies: 3
- Views: 991
.htaccess issue
I am trying to change the url in browser from
and it is not working. What am I doing wrong?
to
I ve written the rule:
Code: Select all
RewriteEngine On
RewriteRule ^contact/?$ /index.php?page=contact [L]
- Fri Dec 08, 2023 5:49 pm
- Forum: Off Topic
- Topic: Problem with shortcuts in Word 2013
- Replies: 1
- Views: 893
Problem with shortcuts in Word 2013
Purchased Office 2013 was installed on two computers. One computer has Win 10 and the other 7. On both, every now and then, the keyboard shortcuts are replaced with other ones. Eg instead of Ctrl + V for pasting, it has Ctrl + Insert. All shortcuts, copy, cut, paste, undo, redo etc are replaced by o...
- Tue Oct 03, 2023 7:42 pm
- Forum: Off Topic
- Topic: how to order correctly in sqlite?
- Replies: 8
- Views: 590
Re: how to order correctly in sqlite?
Thank you very much! One last question. What about having words like the following?
Code: Select all
TEST.ACK.1
TEST.ACK.10
PROD.MX.2
PROD.MX.10
PROD.10
PROD.2
LOG.DAT.10
LOG.DAT.5