Re: [sqlite] Update static database with records from memory database.

2008-07-03 Thread Pejayuk
Thankyou Dennis. You have been a fantastic help. I will be sure to put credits in my script to you all. I am hoping to release this ranking system after its run for a month or so. Eventscripts is free and so are the scripts that get released. I am sure a lot of Counter Strike Source game

Re: [sqlite] Update static database with records from memory database.

2008-07-03 Thread Dennis Cote
Pejayuk wrote: > Thanks Dennis, > I get the gist of it. > > I am getting duplicate records though using insert or replace. > I was using update before. > >>From the TOP. > > When my script loads it does the following fine. > //Open static database. > es_xsql open stats_static |zmstats > //Open

Re: [sqlite] Update static database with records from memory database.

2008-07-03 Thread Pejayuk
Thanks Dennis, I get the gist of it. I am getting duplicate records though using insert or replace. I was using update before. >From the TOP. When my script loads it does the following fine. //Open static database. es_xsql open stats_static |zmstats //Open memory database. es_xsql open

Re: [sqlite] Update static database with records from memory database.

2008-07-02 Thread Dennis Cote
Pejayuk wrote: > I still can't get this to work. > Can someone help please. > > :working: > > > Pejayuk wrote: >> That is fantastic Igor. >> Thankyou. >> All I need to do now is work out how to get an update query to use a >> select query to update the records from stats_memory to stats_static

Re: [sqlite] Update static database with records from memory database.

2008-07-02 Thread Igor Tandetnik
Pejayuk <[EMAIL PROTECTED]> wrote: > I still can't get this to work. Can't get what to work? What specifically seems to be the problem? Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Update static database with records from memory database.

2008-07-02 Thread Pejayuk
I still can't get this to work. Can someone please help. :working: I don't understand how to do this. Many thanks in advance. Pejayuk wrote: > > That is fantastic Igor. > Thankyou. > All I need to do now is work out how to get an update query to use a > select query to update the records from

Re: [sqlite] Update static database with records from memory database.

2008-07-02 Thread Pejayuk
I still can't get this to work. Can someone help please. :working: Pejayuk wrote: > > That is fantastic Igor. > Thankyou. > All I need to do now is work out how to get an update query to use a > select query to update the records from stats_memory to stats_static after > doing the link. > I

Re: [sqlite] Update static database with records from memory database.

2008-06-30 Thread Pejayuk
That is fantastic Igor. Thankyou. All I need to do now is work out how to get an update query to use a select query to update the records from stats_memory to stats_static after doing the link. I think google may be able to help me with that. Thankyou for your time. =) Igor Tandetnik wrote: >

Re: [sqlite] Update static database with records from memory database.

2008-06-29 Thread Igor Tandetnik
"Pejayuk" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is it possible to have a single SQL query execute on the stats_static > stats database and have it update from the records in stats_memory > stats database?. http://www.sqlite.org/lang_attach.html Igor Tandetnik

[sqlite] Update static database with records from memory database.

2008-06-29 Thread Pejayuk
Hi, I'm new to sqlite. I use it on my Counter Strike Source Zombie Mod game server. I use eventscripts to access sqlite. In eventscripts you can open memory databases like so. es_xsql open stats_memory ":memory:" And static databases like so. es_xsql open stats_static |zmstats In the