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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by juergenkemeter

  1. juergenkemeter

    display tool for tables, relations and triggers

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

    Extract data from closed workbooks

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

    Excel data import into PostgreSQL database

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

    Excel data import into PostgreSQL database

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

    Attribute Error using SPE IDE (Stani's Python Editor)

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

    End of file Keyboard shortcut in SPE

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

    Attribute Error using SPE IDE (Stani's Python Editor)

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

    freeware ide or editor for python?

    ok, that helps, will use PythonWIn! Cheers Jurgen
  9. juergenkemeter

    freeware ide or editor for python?

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

    SQL Statement

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

    SQL Statement

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

    Trigger

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

    SQL Statement

    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] --------------------------------------...
  14. juergenkemeter

    Trigger

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

    Table Editor

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

Part and Inventory Search

Back
Top