Search results for query: *

Hi, I have several tables. Some tables also have a trigger attached, to check insert formats, etc. For a better overview, how can I display all my tables, with their relations and triggers, in a sort of diagram? Perhaps there is a (freeware) tool out there? Any help would be good, Juergen

Hi! I have a folder containing about 300 Excel workbooks. These contain the same Sheet names. ('Sequence Data' and 'Sequence Analysis') Each Sheet is divided into several sectors, i.e. rows, with different headings. I must collect all data, written in these different sectors of the sheets...

Hi! I have to import all data, stored in an Excel workbook, into a PostgreSQL-database. Herefore, I export Excel spreadsheets as .csv - files. My actual Python script imports this csv-file, and generated PostgreSQL files (.psql), which contain the SQL statements for filling in the database...

Hi, what is the EOF (end-of-file) keyboard shortcut in SPE (Stani's Python Editor)? Ctrl-d only opens the debugging window. cheers, Juergen

Hi! I get an AttributeError when using SPE with the two scripts below. When using IDLE, this message doesnt occur. First Script reads in data and writes it into a shelve file: [CODE] # Writing to shelve file. import sys import shelve # open shelve file try: outCredit = shelve.open(...

Hi, who knows of a nice freeware ide or editor for programming in Python? cheers, Jurgen

Hi, I have the following Statement: ------------------------------------ select substring('AE0000000',1,9-Length(cast(prid as varchar(7)))) + cast(prid as varchar(7)) + '/' + substring(cast(pryear as char(4)),3,2) from hilfssto.proverw where PRID = [PRID] --------------------------------------...

Hello, I want to make a SQL Trigger with Database Navigator. Here is the SQL-Statement which I tried: ------------------------------------------------ WHEN (PRISTW - PRSOLLW) > 0 THEN SET newrow.PRABWEI = 'Entspricht' ELSE SET newrow.PRABWEI = 'Entspricht nicht'; END...

Hi, I have the following SQL Statement which gives back the Actual Substance Quantity(DECIMAL), e.g. 33.00 [milligram]: ------------------------------------------------------------ Select X.REPOMEN_SUM - Y.REENTMEN_SUM from (Select RECHPFID, sum(REPOMEN) REPOMEN_SUM from HILFSSTO.REBEW...

Hi, I have a field „Actual_Stock”. A SQL-Query gets the actual Stock of the Substance (DECIMAL) and shows it in the field. I also have a DATE – Field “RERETDAT”, where the User types in the Retest Date of the Substance. Is it possible in SQL to make two ‘Alarm functions’, e.g. a pop-up window...

Hello, I have a List Control Field (ListCtrl) in my form, with several columns. Name: COL1, COL2, COL3. Is it possible to address a certain Column in this ListControl in a SQL statement? I want to catch the SUM of a certain Column via SQL. /jk

Hello, I have three fields in my form: - REPOMEN (VARCHAR) - REENTDAT (DATE) - REENTMEN (VARCHAR) I want a SQL Statement which does the following: If in REENTDAT is a Value, then I want to copy the value of REPOMEN into the field [REENTMEN] on the form. Unfortunately my Statement gives back...

Hi, I have several forms which are connected with Buttons. The Insert on the Main Form works without problems. When I wan to Insert on other Forms, I get a Failure Notice: "An error occurred whils running the SQL statement. Duplicate column name XXX in INSERT or UPDATE" I can send you my forms...

Hi, I have built a form for my table in DB2. With the standard Search Button of the Table Editor, I cannot have the following functionalities: - display the count of the found data records - display a table with the search results, displaying only the main atttributes of the data records Is...

Hello, ma subject is the following: take a picture as background, e.g. a land map. Now you should be able to mark different points which should be nummerated and linked with e.g. tables You will probably need Visual Basic for Applications for this problem. Thanx for every kind of help!