Recent content by juergenkemeter

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