| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> oh
<0> thanks
<1> I learned a new thing about TEmbeddedWB it lets you define an external command processor.
<1> now I can have web pages that are displayed within my program and I can process form submissions and trigger other web pages :-)
<0> sounds a bit complicated for me, all i want is to know when a webpage is fully loaded, including a movie clip that might be on it
<1> night
<2> hi all
<3> TextOut(hdc, r.left, r.top, "Defenestration can be hazardous", 4); // haha
<4> http://www.vanishingpointgame.com/
<5> stargatws started again
<5> SG-1
<5> :D
<6> how can i make a TQuery to select only the records for example with field ID, which values are among another field IDs values of another TQuery
<6> like 2 SELECT statements, but with TQueries
<7> Is there a shortcut key combo to temporarily view all files (hidden) in an explorer window? that perhaps i've missed all these years?
<5> anyone have the url mrb posted recently with paintings on buildings?
<8> AK-47[0ff: select * from table where id in (select id from anothertable where somecondition)
<8> AK-47[0ff: on a decent db server.
<5> nm found it
<8> Blade`: ping./
<6> ki9a
<6> i know
<6> but i want to achieve this by using a TQuery component
<8> BDE?
<6> to provide the thata of the inner SELECT statement
<8> good luck.
<8> if it supports joins, you could try a join.
<6> nope, ado, but the idea should be the same
<8> TQuery = BDE
<8> TADOQuery = ADO
<8> and ado doesn't say which db
<6> it's like using the DataSource property of the outer query to access the data of the inner query but it accesses only the current record, not all records :(
<9> Hi all
<9> Is there still no "select @@Identity" support even in Firebird 2?
<10> anyone know how to get the mobile number when someone is offline in msn?
<3> wow what happened with rxlib
<8> Cubud: what would that do ?
<8> FB doesn't do autoinc fields
<8> it uses generators.
<11> sequences?
<8> generators
<8> you could, theoretically use a generator & a trigger
<8> but you can't get back the generated valuue.
<11> and why not sequences like the rest of non-autoincrement dbs?
<11> sounds like another name for sequence
<8> generator = sequence
<8> at least almost.
<11> well why rename an already established standard
<8> CREATE SEQUENCE is a PostgreSQL language extension. There is no CREATE SEQUENCE statement in SQL92.
<11> well it's in oracle etc
<8> it's not like they introduced it just a second ago
<8> note that it seems it DOES support it now
<8> in FB2
<8> create sequence
<9> I have to do 2 commands
<9> select GEN_ID(xxxxx, 1);
<9> insert into (.......)
<9> PITA :)
<11> cant nest?
<8> then you don't have the value
<8> Cubud: other wise you'd have to do:
<8> insert into ...
<8> select LAST_VALUE
<8> the idea is the same
<9> No, that wouldn't work in multi-user environments
<9> The way to do it is like so
<9> select GEN_ID(GeneratorName, 1);
<8> I mean with the @@Identity
<8> you'd still have to use two statements
<9> insert into table(id, name) values (@ID, 'Pete');
<9> Yes, I suppose it is no worse :)
<9> That hadn't occurred to me :)
<9> I thought I had to remove the trigger
<8> you should remove the trigger yes.
<9> but because the trigger checks "if ID = null" then I have the option of only doing the 2nd line when I need it
<8> oh\
<8> yeh
<9> That is what I didn't want to do :)
<9> I didn't want 2 commands for every insert
<9> but I've just realised that the trigger checks for me :)
<8> :)
<9> pandora.com is great :)
<4> anyone watched Afro Samurai yet?
<8> heh
<8> that's actually quite nice Cubud
<9> Have you seen it before?
<9> It learns what type of songs you like
<12> Rahly, I tried but they didn't let me access the stream
<4> no?
<8> Cubud: first tiem
<8> only problem is that it's browser based
<4> lol!
<4> http://www.moderndrunkardmagazine.com/issues/10_06/10_06_andre_giant.html
<9> What is wrong with it being browser based?
<8> it means I'll often close it accidentally ;)
<4> amen, ki9a
<5> rahly: old news
<5> or old url even
<4> still kewl
<5> :)
<9> I have come to the conclusion that SQL Server is crap :)
<8> why is that?
<9> I am importing XML into a table
<9> I start+commit a transaction around each insert
<9> sqlsevr.exe memory usage goes up to 830MB
<8> yes.
<8> :)
<9> Firebird went from 21MB
<8> though it's configurable how much memory it uses
<9> down to 18.5MB
<8> it does use a lot of memory by default
<9> BUt it used more than was available
<9> It was going onto disk memory
<8> oh
<8> that's pretty bad
<9> PC was crawling
<8> I like FB
<9> FB used less memory (16.5MB) *and* finished 4 minutes faster
<8> I have a 2 GB db
<8> and it works perfectly.
<8> 3187060736
<8> 3 gb even
<8> as long as you create the indexes properly of course
<8> Cubud: this radio thingy is pretty cool
<9> It's good isn't it :)
<13> AAAAAAAAAAAAAA!!!! :)
<13> hi Cubud , ki9a
<9> Hi CK :)
<8> Cubud: it works pretty well yes.
<9> I want a website like Pandora.com
<14> whats the name of the function to just Extract Last Folder Name in a path ?
<14> Lastdilimiter .. something is used ;x
<8> Cubud: you ever noticed the complete lack of a decent decimal type in delphi ?
<8> Cubud: officially it's US only btw, the "radio"
<5> ki9a: like System.Decimal in .NET?
<5> didnt u have trouble cross supporting that?
<8> I still do.
<8> :)
<8> (have trouble)
<8> Blade`: I have to somehow convert the .NET/COM (Decimal variant uses the same format)
<8> to delphi
<8> and back
<8> thats going to be interesting.
<9> You can create a Decimal from an array of bytes
<8> yep
<8> array of integer.
<8> but delphis "BCD" type
<8> the one in fmtbcd
<8> the crappy, but unfortunataly only supported bcd type
<8> uses base 100
Return to
#delphi
or
Go to some related
logs:
#nhl
#winvista
toocanx
#politics
irrsi beginner
#hardware
#fedora
rooney has a face like shrek
avista antivirus
#delphi
|
|