Search options

The bike is suppose to have a horn on it to alert forklift drivers and anyone else. But the horns they have been buying have been coming in defective.. I have seriously been considering getting one of these Impact Train Horns, it comes with a wireless button. I would just mount the button to the steering arm and the horn under the basket and then I am set..

https://youtube.com/shorts/LUNiOottntI? … Px2UEQSqfb

The pockets on the inside of the basket are just a cut up Husky Bucket bag. In one of the pictures you will see some modified washers I used. drilled a hole in the husky bag, Then pinched it with 2 washers and some bolts so that the tension is on the washer and not the bag... kind of like a rivet ring.

Original Post has been completely changed to a GUIDE.

OMG Thank You SCORPIO EIGHT ONE ZERO!!!!!!

Used two tables to give the illusion of one table.

SELECT folio AS Page FROM project_summary_view ORDER BY pos LIMIT 26 OFFSET 1

and

SELECT title FROM project_summary_view ORDER BY pos LIMIT 26 OFFSET 1

Didn't have to mess around with the broken UNION operator any more. Prefect

In essence, this is what I was attempting to do. The Title page exists, but not in the Summary and not counted as a folio/page. Additionally, the roman numerals for Table of Contents and folio/page 1 being the actual schematic.

1. SQLite limitations are prohibiting me from making a compound select statement. An error exists when trying to incorporate math and the ORDER BY operator when in a COMPOUND SELECT query with the UNION operator. In fact this error is persistent when using UNION and ORDER BY with various other operators such as REPLACE().

2. Even if I successfully create the SQLite Query that I want, OFFSET is used to OFFSET the table output, as far as I can tell, there is no way to OFFSET the tables before you create the UNION. This means even if I get my roman numerals to appear at the top of the table, I will OFFSET them away when I want to OFFSET other parts of the table.

3. I can't figure out a way to get rid of the Table Header, so I can't even try faking it by creating more than 1 table and just have one sit on top of the other, creating the illusion of 1 table.

4. Now, I could create separate tables and keep the headers and try to build that into the aesthetic of the Summary design. I might write a query for a Table of Contents Table of more than 1 pages something like,

SELECT "I." AS Page, title FROM element_nomenclature_view WHERE pos =  '1' UNION SELECT "II." AS Page, title FROM element_nomenclature_view WHERE pos = '2'

I assume the above query would work, but in order to create the custom width columns by creating individual tables for each column, I would have to just do the above for title only, and manually create the boxes as drawings for the Page column. As an error is created if I don't pull from any specified column.

I could do something really dumb like

SELECT "I,." || date AS Page, FROM element_nomenclature_view WHERE pos = '1' UNION SELECT "II." || date AS Page, title FROM element_nomenclature_view WHERE pos = '2"

However, I would have to leave the date for the table of contents blank

5. Even if, I some how resolve all the issues above. QET does not allow me to modify the custom variables like %{folio-id} with math. Example where %{folio} = 1/30, (%{folio-id}-1) = (1-1) . Here I would be trying to get a result of 0. ((((!!!!!! If there is a way to do this, please please please let me know!!!!!!!!))))))

#5 kills the whole idea. Without a way to modify QET Custom Variables, there is no point in trying to work through the SQLite issues. My Title Blocks on each page will be incorrect even if I solve the summary issues.

Hello Everyone,

Hopefully this is the correct place to post this, Google translate isn't the best...

My Introduction,

I am an industrial maintenance electrician in Atlanta, Georgia, USA, and have done electrical work in the same area for over 12 years now. I have done mainly commercial work, some industrial here and there but made the transition to the maintenance industrial side about a little more than a year ago.

I work for a large company of around 2,000 employees at one of their box plants in Atlanta, Georgia, USA. I am fast tracking my missing knowledge base at my new job with PLCs, electrical schematics, relay logic and more. Honestly, probably the most fun I've had in a long time.

One week, I had to quickly throw together a couple of conveyor lines with nothing but some photoeyes, relays, and a really old Allen Bradly PLC that I didn't have a way to interface with so no idea what it was doing. Managed to get that going but I wanted to make actual prints for my work even though what I threw together was only going to last maybe 6 months before being replaced. That led me to learning about AutoCAD and the sticker price shock led me to learn about QElectroTech

Since then, I have been using my conveyor line as a learning experience and been hacking away at my schematics when time permits. I have been stalking the QElectroTech IRC channel and their Revolt.chat channel for a couple weeks now. They suggested that I post my findings on a few topics that I worked on with summary and nomenclature tables which I plan to do here shortly.

I actually prefer the Euro style of prints over the American ladder logic and am using one of our electrical schematics from one of our production machines that I prefer over the others as a guide. Once I am done with these conveyor line prints, I plan to use these skills on one of our production machines that has very limited and missing prints. If I was hired on here a little sooner, I would probably be using them for 2 of our production machines that are missing their prints entirely, but they are being ripped out and replaced in less than 2 months, so no need.

Thanks,
-FoxTech

I actually got really close with the following statement

SELECT "" || "I." AS Page, title from project_summary_view WHERE title = "Table of Contents" UNION SELECT pos-2, title from project_summary_view LIMIT 26 OFFSET 2

This actually returns all the rows I want, but I can't use the ORDER BY function or else it fails to return any results. The actual result without ORDER BY is very close to what I was attempting to do but it is showing the Table of Contents at the bottom. I also will have additional issues as stated above with the title blocks even if I solve this.

https://www.sqlite.org/lang_select.html#simpleselect

Section 3 Compound Select Statements, almost 3/4 of the way down that page it shows the ORDER BY being used with UNION. However, this is breaking my tables.