Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wengyan

    What does it mean?

    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
  2. wengyan

    How can I list all tables under my schema

    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
  3. wengyan

    How can I list all tables under my schema

    Thx WENG YAN
  4. wengyan

    How can I list all tables under my schema

    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
  5. wengyan

    How can I list all tables under my schema

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

    How about begin a transaction

    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
  7. wengyan

    About TTable->Filter

    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
  8. wengyan

    dbExpress : unable to load libmysql.dll

    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
  9. wengyan

    An OnChange for an AnsiString?

    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
  10. wengyan

    ADO Components Connection Problem

    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...
  11. wengyan

    How to Show Details Records in a column ?

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

    How to Show Details Records in a column ?

    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...
  13. wengyan

    Migrating SQL2K Database to another SQL2K Database

    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
  14. wengyan

    Hi Everybody I am new to SQLSer

    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)...
  15. wengyan

    ListValueCount() type function..

    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
  16. wengyan

    extract a certain part of the database to excel every night

    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
  17. wengyan

    ListValueCount() type function..

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

    changing date format of sql 2000 without reinstallation

    Sorry,I post an mistake thread WENG YAN
  19. wengyan

    changing date format of sql 2000 without reinstallation

    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...
  20. wengyan

    Comparing dates without time...

    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...

Part and Inventory Search

Back
Top