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, The script only processes normal Excel cell values, as these are shown in the csv-file of an Excel spreadsheet. Some Excel spreadsheets also contain cells which link to other spreadsheets, i.e. Hyperlinks. Also, there are some cells which have Excel comments attached. Both the link...

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

the scripts are ok when running in IDLE. The error only occurs in SPE. Juergen

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

ok, that helps, will use PythonWIn! Cheers Jurgen

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

Hi Marc, it does! Thanks for your help! :) Jürgen

Hi Marc, I have no experience with this function. Can you tell me how my statement would look with this function? Jürgen

Hi, thanks for offering your help. I'm glad I recently found a solution to my problem: --------------------------------------------------- WHEN (PRISTW is not NULL and PRSOLLW is not NULL) BEGIN CASE WHEN PRISTW - PRSOLLW > 0 THEN SET newrow.PRABWEI = 'Entspricht'; ELSE...

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 already found a solution yesterday. I don't retrieve data over the ListControl, but with direct SQL over the table. Thanks anyway for offering your help! Here is the solution, just for fun... SELECT DISTINCT CASE WHEN ( Select X.REPOMEN_SUM - Y.REENTMEN_SUM from (Select RECHPFID...

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

Hmm...tricky I would say. I tried the following Statements: --------------------------------------------------- SELECT REENTNDAT, CASE WHEN REENTNDAT IS NULL THEN '' ELSE REPOMEN END AS REENTMEN FROM HILFSSTO.REBEW ---------------------------------------------------...

Hello, I nearly forgot the FROM... Here is what I tried: SELECT REENTNDAT, CASE WHEN REPOMEN IS NULL THEN '' ELSE REPOMEN END AS REENTMEN FROM HILFSSTO.REBEW Unfortunately this gives back the Message: --------------------------- The results in a CASE expression are not compatible. (SQL...