You might want to take a look at the spreadsheet import tool at
http://www.xoetrope.com/xui/demos#spreadsheet
It currently works with MS SqlServer, HSQLDB and we currently are
testing it with Derby (and it shouldn't take very long to get this
working). The tool is intended to enable repeated i
Bryan Pendleton wrote:
>
>> SQL state 42601: ALTER TABLE statement cannot add an IDENTITY column to a
>> table.
>>
>> Is there any way to work around this?
>
> Perhaps:
>
> 1) create a new table with all the columns of the existing table,
> plus the new identity column.
> 2) INSERT INTO
I'm doing something similar with a business application.
There's nothing stopping the user "accidentally" deleting the data on
the local machine either. If the password is held in the software then
it is insecure and can be easily cracked.
It would be better to store the data on a server and
I have a SQL Server query that I am trying to port to Derby but I
can't find the right syntax. Is there any documentation?
The SQLServer query is:
UPDATE TEMP_RATES
SET Level1=RATES.Level1
FROM TEMP_RATES INNER JOIN RATES ON TEMP_RATES .CODENO= RATES .CODENO
WHERE (RATES.UserID=306) AND
ecification and is outside the scope of the join
specification or appears in a HAVING clause and is not in the GROUP BY list."
[EMAIL PROTECTED] wrote:
Luan O'Carroll <[EMAIL PROTECTED]> writes:
I have a SQL Server query that I am trying to port to Derby but I
can'
I have a SQL Server query that I am trying to port to Derby but I can't
find the right syntax. Is there any documentation?
The SQLServer query is:
UPDATE TEMP_RATES
SET Level1=RATES.Level1
FROM TEMP_RATES INNER JOIN RATES ON TEMP_RATES .CODENO= RATES .CODENO
WHERE (RATES.UserID=306) AND ( TEMP_
