Databasecount in Xal for Sql

Hi,

Xal: 3.14 for Sql.

I have a question on Databasecount in Xal for Sql.

After deleting a big amount of records in the databse
and make a new Databasecalculatuion(Xal=DBSizeCalc)

The size of the database have only get a little bit smaler.

It seam that it in same way count the deleted records?

Is it something more we have to do, to get the right size
of the database? Maybe sometihing in the SQL?

Hi, Björn,

I am not sure, whether there is an error or not.
The first thing you should check is the procedure DBSizeCalc. The first 
version of this script, which was delivered for versions prior 3.0, had an 
error for very large tables (more than 2 GB size). The bug has been corrected 
since, so you might check, whether the calculation in the script of version 
3.5 looks similar to the one you are using.
The second question is, how many records you have deleted, and which size 
the records have. This count will give you a hint on the expected change in 
the database size. 10,000 records of 100 byte size give 1.1 MB in calculated 
database size.

Kind regards 
Hannsjörg Zdarsky
Software Design Engineer
Microsoft Deutschland GmbH


"Björn" wrote:

> Hi,
> 
> Xal: 3.14 for Sql.
> 
> I have a question on Databasecount in Xal for Sql.
> 
> After deleting a big amount of records in the databse
> and make a new Databasecalculatuion(Xal=DBSizeCalc)
> 
> The size of the database have only get a little bit smaler.
> 
> It seam that it in same way count the deleted records?
> 
> Is it something more we have to do, to get the right size
> of the database? Maybe sometihing in the SQL?
> 
> 

Björn napisał(a):
> Hi,
> 
> Xal: 3.14 for Sql.
> 
> I have a question on Databasecount in Xal for Sql.
> 
> After deleting a big amount of records in the databse
> and make a new Databasecalculatuion(Xal=DBSizeCalc)
> 
> The size of the database have only get a little bit smaler.
> 
> It seam that it in same way count the deleted records?
> 
> Is it something more we have to do, to get the right size
> of the database? Maybe sometihing in the SQL?
> 
> 
> Regards: Björn     

If You have any problems with new license codes for bigger db, please 
use the folowing cheat script in XAL=autoexec and XAL=autoexit, at the end:

IF SqlVersion() THEN
     SET SQLPrepare('DELETE FROM ' + #XALUTIL + ' WHERE TYPE = 5')
     SET SQLSelect('SELECT * FROM ' + #XALUTIL)
ENDIF



-- 

I do not know the intention of “crisp’s” suggestion. What I do know is
that 
this is definitely a violation of the Microsoft XAL license terms – and this 
can cause problems later on - jeopardizing the installation, data etc…
Regards
Ole Kyhl Jensen [MSFT]
Product Unit Management XAL & C5

================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.



"crisp" wrote:

> Björn napisał(a):
> > Hi,
> > 
> > Xal: 3.14 for Sql.
> > 
> > I have a question on Databasecount in Xal for Sql.
> > 
> > After deleting a big amount of records in the databse
> > and make a new Databasecalculatuion(Xal=DBSizeCalc)
> > 
> > The size of the database have only get a little bit smaler.
> > 
> > It seam that it in same way count the deleted records?
> > 
> > Is it something more we have to do, to get the right size
> > of the database? Maybe sometihing in the SQL?
> > 
> > 
> > Regards: Björn     
> 
> If You have any problems with new license codes for bigger db, please 
> use the folowing cheat script in XAL=autoexec and XAL=autoexit, at the
end:
> 
> IF SqlVersion() THEN
>      SET SQLPrepare('DELETE FROM ' + #XALUTIL + ' WHERE TYPE = 5')
>      SET SQLSelect('SELECT * FROM ' + #XALUTIL)
> ENDIF
> 
> 
> 
> -- 
> crisp

Ole Kyhl Jensen [MSFT] napisał(a):
> I do not know the intention of “crisp’s” suggestion. What I do know
is that 
> this is definitely a violation of the Microsoft XAL license terms – and
this 
> can cause problems later on - jeopardizing the installation, data etc…
> Regards
> Ole Kyhl Jensen [MSFT]
> Product Unit Management XAL & C5
> 
> ================================================
> 

I dont want to piracy, but what can I do if I cannot buy new licence 
codes for db size from MS??? Stop working?

-- 
crisp