Originally posted by: Sanjeev Manglani
Hi,
I just downloaded the Jetsql application , its a nice one but does not support many sql statements such as TODATE etc, if any upgrade to the application has been made plz inform me or if there is any other application that supports executing sql scripts for mdb files ,
Regards,
Sanjeev
Originally posted by: Faisal Zahidi
I am trying create view in my access 2000, and the database is unable to find SQLJET Engine. As a result, I was trying to install JetSQL.exe. It's now giving me error that .DLL file, MSVCP50.DLL was not found in my system. Please let me know what should I do
regards,
Faisal Zahidi
Originally posted by: bag
????
ReplyOriginally posted by: 寒冰
我很想学
但晚我不懂
我该怎么做？？
Originally posted by: xiaqibing
It can not support chiness field!
Originally posted by: vijendra
i am getting trouble with selecting two or more tables
of msaccess in the second step of MFC app wizard here
i am getting an error called "record set is read only"
why ? kindly solve this ..
Originally posted by: David Szutu
CREATE TABLE POP_ACCOUNT
CONSTRAINT popPrimary PRIMARY KEY (popID),
===============
to:
====================
if(t.getTokenType()!=commaT) // expecting a comma
t = m_lexan.GetCurrentToken();
if(t.getTokenType()!=rightpT)
m_lexan.NextToken();
needs to be inserted after line 690, which is:
I've only tested the above changes with a couple of CREATE TABLES.
There's a problem when a CREATE TABLE statement has multiple CONSTRAINT clasues, as in:
(
popID counter NOT NULL,
popUserName varchar(255),
popPassword varchar(255),
CONSTRAINT popUnique UNIQUE (popID, popUserName)
);
JetSQL sees the second CONSTRAINT as an error. A fix is to change the lines in Interpreter.cpp, lines 763 - 777 from:
if(t.getTokenType()==rightpT) break;
if(t.getTokenType()!=commaT)
{
m_show(m_ln,"Comma or right parenthesis missing in the field list of constraint",error);
return -1;
}
}
t = m_lexan.GetCurrentToken();
m_lexan.NextToken();
if(t.getTokenType()!=rightpT)
{
m_show(m_ln,"Right parenthesis missing",error);
return -1;
}
==================
t = m_lexan.GetCurrentToken();
m_lexan.NextToken();
// if a right param then has reached the end of the CREATE TABLE statement
if(t.getTokenType()==rightpT) break;
{
m_show(m_ln,"Comma or right parenthesis missing in the field list of constraint",error);
return -1;
}
m_lexan.NextToken();
if(t.getTokenType()!=constraintT)
{
m_show(m_ln,"CONSTRAINT keyword expected",error);
return -1;
}
}
{
m_show(m_ln,"Right parenthesis missing",error);
return -1;
}
====================
There's also a problem with the use of Foreign Key constraint. The line:
t = m_lexan.GetCurrentToken();
Dave
Originally posted by: Ralph Zeller
Dear Pavel, you have done a great job - thank you.
I like to use your Tool in my SQL lectures at university, because it's exactly what my students need for their SQL training.
At the moment I use SQL*Plus from Oracle and the only different to your tool ist the absence of the following SQL commands:
1. How can I see which tables are defined in my database?
In SQL*Plus I can use:
SELECT * FROM Tab;
where Tab is the name of a system table with all tablenames.
2. How to see which rows are defined in a table?
In SQL*Plus I can use:
DESCRIBE tablename;
3. Renaming of tablenames with RENAME:
ex: RENAME old_tablename TO new_tablename
4. Combining two SELECT statments with MINUS or INTERSECT are missing.
Is it possible to include this commands? Are you planning a GUI version of JetSQL? Are you planning a documentation?
Bye, Ralph.
Reply
Originally posted by: Ralph Zeller
A CREATE INDEX statement like:
CREATE INDEX book_idx ON book (id) WITH PRIMARY;
gives the following error message:
*** Line 2: Semicolon missing behind the statement CREATE TABLE
After changing the code in file Interpreter.cpp, class CSqlInterpreter::CreateIndex() at line 918 from:
if(t.getTokenType()==rightpT) break;
to:
if(t.getTokenType()==rightpT)
{
m_lexan.NextToken();
break;
}
everything worked ok.
A second change might be at line 956 from:
m_show(m_ln,"Semicolon missing behind the statement CREATE TABLE",error);
to:
m_show(m_ln,"Semicolon missing behind the statement CREATE INDEX",error);
Bye, Ralph.
ReplyOriginally posted by: bernard alleysson
Great job !
I'm not an expert in SQL/Jet programming, and
I'd like to know if that way (ie using Jet SQL statements),
is it possible to create/modify relationships between the
database tables ?
More precisely is it possible to create/modify the
inferential integrity options (cascade delete, cascade update)on a table using JetSQL ?