TIP OF THE DAY!!! : SQL request and speed ? III

[Claudius Sailer]

Am 30. Okt 2005 um 19:44 Uhr schrieb Ruslan Zasukhin:

> On 10/30/05 8:35 PM, "Claudius Sailer" <Claudius at sailer-online.de>  
> wrote:
>
>
>>> Yes SQL way takes longer time than API way. And secret not in
>>> parser as I
>>> have think. Main time eat checks of e..g
>>>
>>
>> could you give a short example. Do I need RealBasic Advanced or does
>> API also work with Standard? I have only RB Standard.
>>
>
> This work in Standard also.

Great. I thought it doesn't but it seems that I use it always for  
insert and update.


>
> Point is that you use
>
>     VCursor.AddRecord()  -- this is Sql Way but with some API
>
> Or
>
>    Vtable.AddRecord() -- this is pure API way.


is following API-Way?

   meineDatenbank.TBuchungen.setblank
    Call parsedate(EditField1.text.trim,CheckDate)
    meineDatenbank.TBuchungen.BDatum.Set(CheckDate.year,  
CheckDate.month, CheckDate.day)

   meineDatenbank.TBuchungen.Kategorie_ID.value=AktuelleKategorie

   if EditField4(0).text.cdbl<>0 then
     //Ausgabe
     meineDatenbank.TBuchungen.Betrag.value=RoundTextNumber(EditField4 
(0).text)
     meineDatenbank.TBuchungen.Herk_Konto.value=AktuellesKonto
     meineDatenbank.TBuchungen.Ziel_Konto.value=AktuellesGegenKonto
   else
     //Einnahme
     meineDatenbank.TBuchungen.Betrag.value=RoundTextNumber(EditField4 
(1).text)
     meineDatenbank.TBuchungen.Herk_Konto.value=AktuellesGegenKonto
     meineDatenbank.TBuchungen.Ziel_Konto.value=AktuellesKonto
   end if
   if NOT CheckLeer(EditField5.text) then  
meineDatenbank.TBuchungen.Kommentar.Value=EditField5.text.trim
   meineDatenbank.TBuchungen.Blocked.value=false
   NewRecID=meineDatenbank.TBuchungen.addRecord

   meineDatenbank.TBuchungen.flush



> Again, Valentina have API way -- it allow you do everything without  
> SQL.
> Of course for strong SQL developers it is hard change own mind to  
> start
> think in other way. And of course not all tasks should go to API way.

Thats good :-))


> It is good that Valentina allow mix both

It is always good, that you have several ways to the same result :-))

bye


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 2005r4/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]