Search results for query: *

Users=> show server_version; server_version ---------------- 8.1.0 (1 ?) Users=> \d ERROR: invalid UTF-8 byte sequence detected near byte 0xb1 Users=> WENG YAN

I met another problem. My version of PostgreSQL is 8.1. The database's encoding is UTF8. When I input \d command,it tell me an exception raised as below: Users=> \d ERROR: invalid UTF-8 byte sequence detected near byte 0xb1 Is it related with my database's encoding? WENG YAN

Thx WENG YAN

Thanks for your help. I'm interested in the short commands which could help me manage the database more effectively,could you teach me more? ^_^ For instance, If I want to list the table structure, how could I go in PostgreSQL like desc command in Oracle? WENG YAN

As a novice of PostgreSQL,Could anyone help me? WENG YAN

Hi,all I'm a new player in PostgreSQL.I'm familier with oracle before. Can anyone tell me how to commit transaction explicitly. WENG YAN

I set filter property of ttable.I found a strange issue. I must append a space in my filter string.such as " SHJE=1000" if ommitted space,it will raise "Capbility not supported" exception.Can anybody explain it to me,thanks. WENG YAN

I think the problem is bcb can't find dbexpress driver for mysql(such mysql.dll u mentioned). I met the same problem of mssql server.U can find mysql.dll at delphi 7 or bcb6 Enterprise installation CD.Find it and copy it to [BCB Home]\bin or [system32]. WENG YAN

Why not use a global object? It will centerlize managing all global vairables. All model only use getXXX and setXXX to get or set variable's value. So I think the setXXX method is what u want an OnChange event. WENG YAN

I think the question is because of ADO using cached connection.In ADO ,microsoft will pooled ado connection automaticlly. We know a database connection contains server process and client process.So when connection disconnected suddenly,the client process will not be destroyed.So u use...

You also can find at FAQ (Concatenating a one-to-many relationship into a single column ) faq183-2146 WENG YAN

I establish enviroment to test CREATE TABLE Countries ( CountryID int identity NOT NULL, Country varchar(50), CONSTRAINT PK_Countries PRIMARY KEY(CountryID) ) CREATE TABLE States ( StateID int identity NOT NULL , CountryID int NOT NULL, State VARCHAR(60), CONSTRAINT PK_States PRIMARY...

Hi multiplex77 You can do it by SQL Server Enterprise Manager which will wizard you by GUI. So you can detach a database and attach the database without knowing any SQL Statement,also you can backup the database and retore the database on other server easily. WENG YAN

In SQL Server 2000 Is it right to you? DROP TABLE TMP GO CREATE TABLE TMP (A INT, B INT) GO INSERT INTO tmp values(1,0) INSERT INTO tmp values(2,3) INSERT INTO tmp values(2,4) INSERT INTO tmp values(2,41) INSERT INTO tmp values(3,6) INSERT INTO tmp values(3,7) INSERT INTO tmp values(3,8)...

I am very poor of cold fusion I changed my solution,is it help for you? create view v_tmp AS select col,count(*) from yourtable group by col select * from v_tmp WENG YAN

You can export a specified table to another database(not only SQL Server,but also other datasource).And you can establish a job that run periodly. WENG YAN

select col,count(*) from yourtable group by col WENG YAN

Sorry,I post an mistake thread WENG YAN

SELECT GETDATE() TODAY, DATEADD(DAY,-1,DATEADD(month,1,CONVERT(datetime,convert(varchar,datepart(year,GETDATE()))+'-'+convert(varchar,datepart(month,GETDATE()))+'-1'))) AS [The lastest day of month] TODAY The lastest day of month...

DECLARE @Date_Eligible datetime SELECT @Date_Eligible ='2002-09-24 23:27:16.000' SELECT GETDATE() NOW,@Date_Eligible Date_Eligible,'TRUE' RESULT WHERE DATEPART(year,@Date_Eligible)=DATEPART(year,GETDATE()) AND DATEPART(month,@Date_Eligible)=DATEPART(month,GETDATE()) AND...